Project Health Calculation
Please can you assist.
I am currently using the SS Standard template Schedule Health Formula :
Project Heath Formula
=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green"))
My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas below which use duration)
How can I adapt the formula to revert to the parent health where duration is Zero ?
Schedule Delta Formula :
=IFERROR([Schedule Delta (Working Days)]@row / Duration@row, "")
Schedule Delta (Working Days) :
=IFERROR(IF([End Date]@row = [Baseline End Date]@row, 0, IF([End Date]@row > [Baseline End Date]@row, NETWORKDAYS([Baseline End Date]@row, [End Date]@row) - 1, IF([End Date]@row < [Baseline End Date]@row, NETWORKDAYS([Baseline End Date]@row, [End Date]@row) + 1, ""))), "")
Many Thanks
Lee
Answers
-
@leezee I responded on your other thread.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!