Modified At and Modified By is updated for multiple rows
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!
Answers
-
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/articles/2482767-automatically-update-today-in-formulas
-
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!
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives