Calculate Status Column by %Complete

Trying to set status column based on % complete - I can make the formula work with just the first statement - =IF([% Complete]@row = 0, "Not Started")

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

Anyone know how to make the above formula work?


Best Answer


  • @Mike Raposo - Ah that makes sense, it did the trick. Thanks a bunch!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!