IF Formula Help
Hi guys,
I would like to implement the following automation process of "% Complete" > "Status".
The approach would be:
 IF: % Complete: 0% > "Not Started"
 IF: % Complete: 0% ≤x≤ 100% > "In Progress"
 IF: % Complete: 100% > "Completed"
My current IF formula does not display and consider the last 2 conditions, I honestly do not know why.
Could anybody help me on this? :)
Many thanks in advance!!!
Best regards,
Torsten
Best Answer

Hello Torsten,
You can try the formula below. The thing to remember with nested IF statements is that they get processed from left to right. This allows for logic on the last IF statement to simply look for greater than 0, but still show as complete when it equals 1, as the second IF statement takes priority over the last one.
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress")))
Hope this helps.
Answers

Hello Torsten,
You can try the formula below. The thing to remember with nested IF statements is that they get processed from left to right. This allows for logic on the last IF statement to simply look for greater than 0, but still show as complete when it equals 1, as the second IF statement takes priority over the last one.
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress")))
Hope this helps.

Amazing, it works!! Thanks a lot Tim!! :)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 444 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 290 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!