Health Formula

Kelsey L DeOrdio

This is my current formula. I have added a drop down option in my status column "NA". I have also changed my health column to include a gray light option. Can someone help me add this to my current formula. IF (Status@row = "NA", "Gray".

=IFERROR(IF(Status@row = "Complete", "Green", IF(AND(Status@row = "Not Started", [Task Start Date]5 <= TODAY(5)), "Red", IF(AND(Status@row = "In Progress", [Task Start Date]5 <= TODAY(10)), "Yellow")))), "")

Philip Robbins

=IFERROR(IF(Status@row = "NA", "Gray",IF(Status@row = "Complete", "Green", IF(AND(Status@row = "Not Started", [Task Start Date]5 <= TODAY(5)), "Red", IF(AND(Status@row = "In Progress", [Task Start Date]5 <= TODAY(10)), "Yellow"))))), "")

This should do the job. Let me know if not.

Philip Robbins

@Kelsey L DeOrdio you certainly can. You would need to set up an automation with the following logic:

When rows are changed and when 'Date Started Column' changes to 'Any value', change a cell value ('Status' changes to 'In Progress').

Philip Robbins

=IFERROR(IF(Status@row = "NA", "Gray",IF(Status@row = "Complete", "Green", IF(AND(Status@row = "Not Started", [Task Start Date]5 <= TODAY(5)), "Red", IF(AND(Status@row = "In Progress", [Task Start Date]5 <= TODAY(10)), "Yellow"))))), "")

This should do the job. Let me know if not.

Kelsey L DeOrdio

@Philip Robbins This helped!

One more question..

I set up my status column to default to "Not Started"

I have a column where I enter the date I started a task.

Can I set the status column up to change to "In Progress" when a date is entered there?

Philip Robbins

@Kelsey L DeOrdio you certainly can. You would need to set up an automation with the following logic:

When rows are changed and when 'Date Started Column' changes to 'Any value', change a cell value ('Status' changes to 'In Progress').