RYG Status When Row is Complete

Sinema

Greetings,

I'm working on a complaint tracker and I'm trying to come up with a solution to this issue.

I'm using a status RYG column that is tied into the Date Created.  The problem is, when the row is "Complete" and I've created a condition to mark out the row when completed..

But the Status still ages with the date.  I'm wanting to do a dashboard that shows accurate issues that haven't been addressed, but it's showing issues that were completed on time as Red issues because the data isn't stopping.

 

Any thoughts? 

Andrée Starå

Hi Sinema,

If I understood your question correctly, you would add the Complete part first so if that is true it will show as green (or something else if you'd like).

Try something like this.

=IF(Status@row = "Complete"; "Green"; IF([Date Created]@row < TODAY(); "Red"; IF([Date Created]@row > TODAY(); "Yellow")))

The same version but with the below changes for your and others convenience.

=IF(Status@row = "Complete", "Green", IF([Date Created]@row < TODAY(), "Red", IF([Date Created]@row > TODAY(), "Yellow")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting