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?
Thanks!
Best Answer

When writing formulas for a % Complete you have to use the decimal form of the value in the formula. Additionally, in order to check against multiple conditions you have to use the AND() function. This formula should work:
=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row >= 0.01, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))
Let me know if you have any questions!
Hope this helps!
Mike
Answers

When writing formulas for a % Complete you have to use the decimal form of the value in the formula. Additionally, in order to check against multiple conditions you have to use the AND() function. This formula should work:
=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row >= 0.01, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))
Let me know if you have any questions!
Hope this helps!
Mike

@Mike Raposo  Ah that makes sense, it did the trick. Thanks a bunch!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!