RYG Status When Row is Complete

Sinema ✭✭
edited 12/09/19 in Smartsheet Basics


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å
    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!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.