RYGG health linked to status and date

Jessica Griffin

I can't wrap my head around the formula. I would like the status column to update the health column.

Not Started - Blue

In Progress - Green

On Hold - Yellow

Completed - none

Any status that also has passed it's due date should be Red

Any help is appreciated!

Andrée Starå

Hi @Jessica Griffin

I hope you're well and safe!

Try something like this.

=
IF(AND(Status@row <> "", [Due Date]@row < TODAY(), [Due Date]@row <> ""), "Red", 
IF(Status@row = "Not Started", "Blue", 
IF(Status@row = "In Progress", "Green", 
IF(Status@row = "On Hold", "Yellow", 
IF(Status@row = "Completed", "")))))

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Jessica Griffin

I hope you're well and safe!

Try something like this.

=
IF(AND(Status@row <> "", [Due Date]@row < TODAY(), [Due Date]@row <> ""), "Red", 
IF(Status@row = "Not Started", "Blue", 
IF(Status@row = "In Progress", "Green", 
IF(Status@row = "On Hold", "Yellow", 
IF(Status@row = "Completed", "")))))

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jessica Griffin

@Andrée Starå Thank you! Other than removing the extra 'e' in Date, that worked perfectly.

Andrée Starå

@Jessica Griffin

I've fixed the double e now. ;)

Excellent!

You're more than welcome!