Task Status Autofill based on % Complete and On Hold Flag
Hello,
I would like to autofill my task status column to "Not Started", "In Progress", "Completed", or "On Hold". Not started, In progress, and completed would be based off a completion %, and On Hold would be based off a flag called "On Hold". I would like to keep this flag so we can use it for roll ups in our dashboards if possible.
"Not Started", "In Progress", "Completed" can be completed using function =IF([% Comp]@row = 0, "Not Started", IF([% Comp]@row = 1, "Completed", "In Progress"))
"On Hold" can be completed using function =IF([On Hold]@row = 1, "On Hold")
Can anyone let me know of a way to say use % completed unless On Hold flag is set and then always use "On Hold" as Status until flag is cleared?
Best Answer
-
Try this: =IF([On Hold]@row = 1, "On Hold", IF([% Comp]@row = 0, "Not Started", IF([% Comp]@row = 1, "Completed", "In Progress")))
Answers
-
Try this: =IF([On Hold]@row = 1, "On Hold", IF([% Comp]@row = 0, "Not Started", IF([% Comp]@row = 1, "Completed", "In Progress")))
-
@Nic Larsen Thanks so much for the help on this issue. Worked like a charm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!