Smartsheet Modified at cell capturing on Log in issue
We are trying to build an end of day report that shows the updates that were made to open tickets throughout the current day.
However, for some reason every day when my user logs in, the sheet seems to capture changes to every cell marked "Open" in the sheet, and the modified date to all the open rows in the sheet gets updated.
Does anyone have an idea as to why the modified date is changing even if no changes are being made??
- Filter on the report
- Report showing all the tickets modified a the same time by the same user at the time she logged in
Answers
-
Do you have any formulas in the sheet that use the TODAY function?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes, the sheet only has 2 and they're both for aging, the rest of the dates are either manual or captured using automation. The formulas and automations can be found below.
I have an aging formula,
I have a resolved age to catch time between a ticket being closed, and verified
-
The column formula with the TODAY function is what is causing the updates. The TODAY function is updating on the back end to today's date when the sheet is activated for the first time each day.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!