We use the WBS for our project plans and indicate milestones by setting the duration to 0 and the start and end date as being equal. Our current column formula is
=IF(ISBLANK([Start Date]@row ), "", IFERROR((IF(OR([Start Date]@row = "", [Start Date]@row > TODAY()), "Gray", IF(OR([% Complete]@row = 1, [End Date]@row > TODAY(3)), "Green", IF([End Date]@row < TODAY(), "Red", IF(NETWORKDAYS(TODAY(), [End Date]@row ) < 3, "Yellow", "Green"))))), ""))
On the first line that is skipped in the WBS, we want the overall health of the project to be based on the health of tasks that are milestones. Right now, the health shows as a green circle symbol as long as the task that is the end date of the project is not yellow or red. We consider the overall health of a project to be Yellow or Red based on how we are tracking to milestones.
Is there a column formula that can be applied to the Schedule Health column that would give me the results I'm looking for, or can I convert the column formula to cell formulas and replace the formula in the cell for the overall health with a different one based on milestone health?
