Health formula

I have a Percentage Complete and a Expected Percentage Complete column that I use for my Health calculation.
The Percentage Complete is manual, based on actual completion. The Expected Percent Complete is a formula based on how much shoudl be completed based on Start and End Dates: =IF(Status@row = "Pending", 0, IFERROR(AVG(CHILDREN()), IF([End Date]@row <= TODAY(), 1, IF([Start Date]@row >= TODAY(), 0, IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, TODAY()), 0) / NETWORKDAYS([Start Date]@row, [End Date]@row)))))
My Health formula compares Percentage Complete and Expected Percentage Complete to calculate Health: =IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row < [% Complete]@row + 1, "Hold", "No"))))
I want to change the parameters for "Hold" so that if Expected Percent Complete is 10% or greater than Percent Complete, "Hold"
Any ideas?
Best Answer
-
That would look more like the portions in bold:
=IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row >= [% Complete]@row + 0.10, "Hold", "No"))))
Answers
-
That would look more like the portions in bold:
=IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row >= [% Complete]@row + 0.10, "Hold", "No"))))
-
That worked.. I did need to make one change:
=IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row <
=
[% Complete]@row +0.10
, "Hold", "No"))))Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!