Formulas do Percentage Row or Colum
Hello, I need some help. I'm trying to create a formula that if the status row is 100 %, the status row will change to "complete", and if it less than 100% = "in progress" and 0%= "not started" Also I'm not using any dependencies?
Best Answer

Try this. I have a field called status that contains this formula. It looks at the field called "% Complete" on the same row.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
When something is 100% complete, the value is 1, so the first argument would set it to complete. If that is not true, then it looks to see if it is greater than 0 and sets it to in progress. Otherwise, it will set it to not started by default.
Answers

Try this. I have a field called status that contains this formula. It looks at the field called "% Complete" on the same row.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
When something is 100% complete, the value is 1, so the first argument would set it to complete. If that is not true, then it looks to see if it is greater than 0 and sets it to in progress. Otherwise, it will set it to not started by default.


Thank you Clydene. Now you make my b so easy

Glad to help.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 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
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!