Hi Community,
I am trying to create a new column labeled "Class" using multiple formulas from different columns. There are 4 levels of Class (0,1,2,& 3). Depending on the value in the position, criticality and staff ID field, this will populate the level. Level 2 is the only formula that will include IS NOT EQUAL. I am getting an error and I think it may be the "else" expression or possibly the order?
Logic on Levels:
IF [Position]="Chairman" or "Deputy Chairman" and [Criticality]= "Critical" then "Level 0"
IF [Position]="Vice Chair" or "National Partner" and [Criticality]= "Critical" then "Level 1
IF [Staff ID]= "24098" or "16000" then "Level 1"
IF [Position]!="Vice Chair" or "National Partner" or "Chairman" or "Deputy Chairman" and [Criticality]= "Critical" then "Level 2"
IF [Criticality]="Other" then "Level 3"
Solved! Go to Solution.
@mlim0806 The IF Else statement was not correct
Thank you for the quick response! It worked! I had another formula further in the workflow that needed Staff ID to be a string, but I was able to use the select tool to just change it back.