Modify criteria for Schedule Health
Hello,
I am trying to modify the criteria for the Schedule Health using the Project Management Office Template (https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8)
Currently it calculates the health based off of the actual and target start/end dates, however, I'd like for it to also factor in the % complete. For example, say a resource is "done" with their task, the status is complete and the dates align, however, the task is actually only 50% done. Based on the 50% completion, it should be yellow.
Additionally, I'd like to add blue for complete. I see how to add this in the column, but I'm unclear where to define this criteria to designate what each health status should mean.
Thank you!
Answers
-
If you are a licensed user and/or sheet admin to the sheet you can edit the formula to include the %complete ranges for each color. You can also edit the column properties and change the default RYG to RYGB.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!