Project Health for Next 60 Days

HelpMePlan

Can someone please help me create a formula to indicate the health of a project via Green, Yellow, and Red spheres for activities in the next 60 days? Currently, I have the health of the project shown on the dashboard for all activities over the duration of the project.

Shanky Paul

Hi,

Here is a sample formula:

=IF([Due Date]@row <= TODAY() + 60, IF([Status]@row = "Completed", "Green", IF([Due Date]@row <= TODAY(), "Red", IF([Due Date]@row <= TODAY() + 7, "Yellow", "Green"))), "")