Edit Column/Row Without Triggering the "Last Modified" Cell

edited 12/09/19 in Smartsheet Basics

Hi there,

I`m trying to create a color code that shows the tows update status. I came up with this formula:

=IF(ABS(Modified1 - TODAY()) > 30, IF(ABS(TODAY() - Modified1) > 90, "Red", "Yellow"), "Green")

the formula works fine, but if I start working on a new row, I want the color code to be applied automatically, which can not be done without editing a new row beforehand, which would trigger the last modified cell to appear. See the Problem?

I guess what I`m trying to ask is how to apply the formula for the entire column, without the modified timestamp being triggered.

Maybe, you can think of another way to achive this too.