Forum Discussion
Calculated column formula vs Powerapps form formula
Hi, I have a calculated column that is automatically assigning a classification based on a number series AS = 1-1999 QX = 2000-2999 OO = 3000-3999 =IF(ISBLANK([Flight #]),"",IF(VALUE([Flight #])...
RenPNW the logic of your formula is wrong; the last part of it says "IF(VALUE(datacardvalue1)>=1,"AS" but all values will be greater than or equal to 1. So the very first thing you need to do is to change that last part of the formula to <2000.
But then how are you going to decide whether a 9000 number is assigned AS or OO?
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Thanks Rob,
I will try that change.
That is the reason that I changed to a choice box so that it can be manually entered for 9000 series.
I will try that change.
That is the reason that I changed to a choice box so that it can be manually entered for 9000 series.