Stuck with an IF Formula
I wrote a IF formula for a status column that is based on % complete
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "Active"))
What I want to add if there is a check box in the Task On Hold to change the status to "On Hold" which is one of the drop downs.
I am having trouble incorporating another column logic into the status.
Is it possible to accomplish the IF statement to take into consideration?
Thank you in advance!
Best Answer
-
Hello Carl,
You were almost there! Here is one solution.
=IF([Task on Hold]@row = 1, "On Hold", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "Active")))
Let me know if this is not what you had in mind and we'll tweak it until it fits your needs
Answers
-
Hello Carl,
You were almost there! Here is one solution.
=IF([Task on Hold]@row = 1, "On Hold", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "Active")))
Let me know if this is not what you had in mind and we'll tweak it until it fits your needs
-
KDM, this worked great, thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 376 Global Discussions
- 206 Industry Talk
- 437 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives