Tracking the overall RYG trend


We would like to track the # of weeks a project has been in its current status (e.g., # of weeks in Red). For example, has a project just turned red or has it been red for 6 weeks in a row?

So far, I've figured we could keep a separate sheet whether the week's status is recorded (RYG), but how can I count the # of weeks it has been unchanged?


  • Jona_g28
    Jona_g28 ✭✭✭✭

    Why don't you setup a workflow that records a date (requiring a new column to be added on your sheet) when the status changes? For the calculation could you use the created date for that row? Would that not work?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @ccwells

    I hope you're well and safe!

    You can add multiple so-called helper columns that could register the change date through a Workflow and use that for all the status options and measure the time between each.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!


    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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


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

    W: | | P: +46 (0) - 72 - 510 99 35

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!