I am struggling with the PMO template and the Schedule Health column in the Project Plan, which is indicating 'Red' even after a Task is complete, with this formula.
=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green"))
Could I use a formula to ask it only to count if "Status" is In progress, or Not started? Will this mess up other formulas in the sheet or the parent rows?