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

Raste

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.

 

Cheers

Raste

Andrée Starå

Hi Raste,

Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a workaround, the third-party service, Zapier is an excellent option for this scenario. Is that an option for you?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

Raste

Thanks for your reply,

yes, Zapier might work with this one but for now I`ll just use the conditional formatting to get a similar effect.

Andrée Starå

Excellent!

Happy to help!

Mike Wilday

Yes, I was thinking conditional formatting might be the way to go. I don't know if it affects the last modified date or not, but the chances are pretty likely that it won't. 

Raste

You are right, it does not. Not quite what I wanted but a good enough workarround.

Mike Wilday

Awesome. Glad I could help confirm the right direction.

You could create a column called flag and then apply the color formatting to that field only. 

Mike Wilday

The column would be blank but colored appropriately. You wouldn't be able to filter by it specifically but it would give you the colored look you're looking for.