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.
