"=IF" statement not generating correct response all of the time
Hi Everyone!
I am trying to get my status column to change based upon what the number is the [% Complete) column is. Here is what I would like the desired results to be:
0= "Not Started"; 100="Complete"; and anything else from 199 would be "In Progress"
Here is the formula that I have tried, but it's not catching that 100% should be "Complete".
=IF([% Complete]@row = 100, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
Here is screenshot of the error.
Best Answer

You are very close. Smartsheet reads percentages as a decimal. so 100% = 1, 50% = 0.5, etc. All we need to do is adjust accordingly.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
Answers

You are very close. Smartsheet reads percentages as a decimal. so 100% = 1, 50% = 0.5, etc. All we need to do is adjust accordingly.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))

OMG, I wish I had asked sooner, I spent 3 days trying to figure this out on my own. Thank you soooo much!!!

Happy to help! 👍️
Don't hesitate to visit/reach out to the Community. There is a lot of knowledge floating around here, and even if you figure the answer out, you can always Comment on your own question with the solution and flag it as the Accepted Answer. That way if anyone else happens to be encountering the same problem or looking for a similar solution, they might be able to learn from your post.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!