Options
✭✭

I have a hit roadblock, and I needed a little help or additional eyes. The formula should be something of ease, but not working or responding the way it should. Please see my screen shot below. Everything about this works except for when I hit 100%. It does not return my “6-Complete” Statement. When it hits 100% it remains in “1-In Progress”. I have tried reversing the 0 and 100 and still did not work. Let me know if you see anything that I might have overlooked. Thank you

• ✭✭✭✭✭✭
Options

You are very close. Percentages are treated as decimals: 1 = 100%, 0.5 = 50%, etc.

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

• ✭✭✭✭✭✭
Options

You are very close. Percentages are treated as decimals: 1 = 100%, 0.5 = 50%, etc.

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

• ✭✭
Options

Amazing.. It worked. Thank you very much

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!