Modified At and Modified By is updated for multiple rows

Saad

I just checked it using highlight changes to Today but these rows haven't been changed at all. Yet Modified At and Modified By was updated.

Another point here is it that only Modified By and Modified AT are highlighted in a row.

Which means no changed were made to them directly and it is not a comment either because Modified By is the name of a user not discussion.system@smartsheet.com.

I am using a formulae for activity status but that is just if and else condition and is not updating any row but only updates itself.

Lets say :

If column A is "Z" then "Gray", IF column A is "X" or "Y" and is less than 7 days of a date then "Green",IF column A is "X" or "Y" and is more than 7 but less than 14 days of a date then "Yellow",

Else "Red"

Automations types:

1 - only to record date when a specific field is changed.

2 - when a row is added then record a date

Thank You!

ker9

If a formula on the sheet contains TODAY(), this can happen. It will be updated by whomever/whatever triggered it possibly by opening the sheet.

https://help.smartsheet.com/function/today

https://help.smartsheet.com/articles/2482767-automatically-update-today-in-formulas

Saad

Option1 ,

this will update the helper column every day and hence it updates the `Modified At` as well. Will it not?

Option2,

Creating a separate sheet and adding today's function in any cell of that then linking it to the source sheet has to work correctly. As this will update today's date in the reference sheet, not the source sheet.

Am I Right?

Please Advise!

Paul Newcome

It is updating the TODAY function on the back-end. Even though there is no visible change, the change to the back-end data is being updated and is therefore updating the modified column.