Highlight Cells based on time stamp

Options

Hello,


I would like to highlight all rows if "CREATED" cell is greater by 15 minutes than "MODIFIED" cell.

I have no idea how to go about it.

Answers

  • Genevieve P.
    Options

    Hi @Diego Casillas Zaragoza

    If you're using the two System Created columns, you can subtract one cell from the other to find out the difference between the two:

    =Modified@row - Created@row

    This difference will include time, meaning that if the number is greater than 0.01, the Modified date column is more than 15 minutes older than the Created date. Then you can set up a Conditional Formatting rule based on your formula column:

    An alternative would be to use the Highlight Changes feature built into the sheet. (See: Highlight Changes Made to a Sheet)

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!