IF this, if this, if this, if not formula help

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row <= 0.99, IF([% Complete]@row >= 0.01, "In Progress", IF(Review@row = 1, "Review")))
This formula works perfectly. Until I add this at the end, "To Do".
If it doesn't fall into one of the categories, I need it to say "To Do".
I've tried multiple things, but it just won't work all together.
This is an expanded Status update. Thank you
% Complete is 1 = Complete
% Complete is 01-.99 & Flag is 0 = In Progress
% Complete is 0 & Flag is 1 = Review
otherwise = To Do
Thank you!
Answers
-
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row <= 0.99, IF([% Complete]@row >= 0.01, "In Progress", IF(Review@row = 1, "Review", "To Do"))))
Should just need to update your final FALSE IF statement with "To Do".
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
@Jason Tarpinian Thank you. Not sure what was happening, but I am good to go now.
Thanks so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!