If(AND(OR statement for Project health based on status
Need to know:
Health - green, yellow, red
Statuses - Defining Requirements, In Review, Reviewed, Validated
There are dates that we want the project to be in the Reviewed status by. I'm trying to write a script that will allow me to set a "red", "yellow", or "green" health score based on the status of the program and the date. For instance, if the date is the date in the Reviewed status column, but the status is In Review or Defining Requirements, I was the health column to show red. If the date is a week away, but the status is In Review, the health should be yellow. If the Reviewed status is reached before the date, the health should be green. Can someone help me with this?
Help Article Resources
Check out the Formula Handbook template!