Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Highlight If Older Than 'X' Days

D Domine
D Domine ✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days.  It's helpful for us to see which tasks are stale.

However, there's only an option for "In the last 'x' days" or "older than (a date)".  Has anyone found a good workaround or submitted this as a feature request?


  • Greg Gates
    Greg Gates ✭✭✭✭✭

    I think it's a great feature to request! In the meantime, I can think of at least two workarounds:


    1) Format everything in your column or sheet to have a red background (or whatever you want the "late" color to be). Then, in your conditional formatting, have it change the cell background to the normal white color if it's "In the last 30 days." It's kind of backwards thinking, but should technically produce the desired effect.


    2) Create a new column solely for calculating the age of a task. Your formula could look something like "=TODAY() - [Date Column]1". Then, apply your conditional formatting to the desired cell/row based on the value in this column if the value is bigger than 30.

  • D Domine
    D Domine ✭✭✭✭

    Thanks Greg.  You nailed the two ideas our team came up with.  Gives me great confidence we're doing all we can until they add that as a feature.  

  • Kennedy Stomps

    Hi D-- This is on our enhancement request list and I'll add your vote for it. In the meantime, Greg has provided two great workarounds--thanks for sharing those, Greg!

  • Robert Chapman

    Add my vote as well please. 



  • RNelson
    RNelson ✭✭✭✭

    Has this enhancement been added since this post? If not, can you add my vote as well.

  • LLisa

    Has anyone found out if they have added this feature yet?

This discussion has been closed.