Formula for status update using number of workdays until finish
I need help with a workday formula. I'm trying to get my status bubbles to update automatically based on the number of days until task completion. I've got it to work counting backward using all days with the formula below, but I can't figure out how to only count workdays. Any help is appreciated.
=IF([% Complete]@row = 1, "Blue", IF(TODAY() > Finish@row - 3, "Red", IF(TODAY() > Finish@row - 7, "Yellow", IF(TODAY() > Finish@row - 8, "Green"))))
Best Answer
-
I believe you can just use WORKDAYS.
IF(TODAY()>WORKDAYS(Finish@row, -3), "Red")
Answers
-
I believe you can just use WORKDAYS.
IF(TODAY()>WORKDAYS(Finish@row, -3), "Red")
-
Thanks Lucas. I had to change it to WORKDAY instead of WORKDAYS, but your suggestion worked.
=IF([% Complete]@row = 1, "Blue", IF(TODAY() > WORKDAY(Finish@row, -3), "Red", IF(TODAY() > WORKDAY(Finish@row, -7), "Yellow", "Green")))
-
Glad you got it working!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 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!