IFS() Is not working.

[Mauricio_Bick]

I have a column called Progress of percent type where the user can pick between 25%-100%.  I have another column called Work Order Status.  In the Work Order Status column, I have the following App Formula :

IFS(
DECIMAL([Progress])=.25,"Work Started",
DECIMAL([Progress])=.50,"Halfway Done",
DECIMAL([Progress])=.75,"Finishing Up",
DECIMAL([Progress])=1,"Completed")

I have to change it to Decimal because if I don't then the formula won't work.

When testing the formula it seems to work but it doesn't save the expression result for some reason.  Please look at the pics below.

@AleksiAlkio 

[Denny774 · Accepted solution]

Hey,

try this:

SWITCH([Progress], 0.25, "Work Started", 0.50, "Halfway Done", 0.75, "Finishing Up", 1.00, "Completed", "Unknown")

😉

[AleksiAlkio]

When you open the record with the form view, does it work properly without DECIMAL() before you click save?

[Mauricio_Bick]

@AleksiAlkio I tried what you suggested and it doesn't work. I tried it with a new record and editing one but still nothing.

[AleksiAlkio]

How have you specified the % column and its values?

[Mauricio_Bick]

Like this

[Denny774 · Accepted solution]

Hey,

try this:

SWITCH([Progress], 0.25, "Work Started", 0.50, "Halfway Done", 0.75, "Finishing Up", 1.00, "Completed", "Unknown")

😉

[AleksiAlkio · Accepted solution]

You need to use 0.25 instead of .25 and the same with other values.

[Mauricio_Bick]

The problem was that I wasn't including the leading zero.

Thank you @AleksiAlkio & @Denny774