#UNPARSEABLE

ScottBeaver

I cannot get this formula to work.  Any suggestions?

=IF([% Complete]1=0%,"Not Started",IF([% Complete]1=100%,"Completed","In Progress"))

Andrée Starå

Hi Scott,

Smartsheet looks at the numbers in a column formatted for percentage (for example, a % Complete column) as values between 0 and 1. Use decimal values (examples: 0.25 for 25%, 0.5 for 50%) to get the correct comparison, as opposed to whole numbers.

Try this.

=IF([% Complete]@row = 0; "Not Started"; IF([% Complete]@row = 1; "Completed"; "In Progress"))    

The same version but with the below changes for your and others convenience.    

=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Completed", "In Progress"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting