Project Plan Formula Not Working.

Bnizzle

I am trying to get my "schedule health" column to update based on my dates and or "status" column, I've tried multiple formulas but can't seem to get it right; going at if for two days now. If you're able to help in anyway, I would greatly appreciate the support :). Thank you in advance!!

Formula #1 semiworks, yellow, gray and green populate in the "status health" column correctly, but RED never populates

=IF([Actual Start Date]@row = "", "Gray", IF(AND([Actual Start Date]@row <> "", [Actual End Date]@row <> ""), "Green", IF([Actual Start Date]@row <> "", "Yellow", IF(AND([Actual Start Date]@row <> "", [Start Date]@row < TODAY()), "Red"))))

Formula #2 says #INCORRECT

=IF([Actual Start Date]@row = "", "Gray", IF(AND([Actual Start Date]@row <> "", [Actual End Date]@row <> ""), "Green"), IF([Actual Start Date]@row <> "", "Yellow", IF(AND([Actual Start Date]@row <> "", [Start Date]@row < TODAY()), "Red")))

Naeem Ejaz

https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8

From this template pick the project plan document and look into it.

It has a health formula working.

Bnizzle

Thank you, Naeem. That template uses the percent column to trigger the heath status, i want to remove the % column and use the date columns to trigger the status health. Any thoughts?