System Field: Date/TimeStamp behaviour

Hi all,

Have been a fan and avid user of SmartSheet since 2015. Great to see all the continual roll out of new capabilities / functionality.

I am currently working on building a triggered notification on SmartSheet -- essentially, if a specific row has not been updated for "x" days, it will fire a notification to a specified user.

Proposed approach:

- Create a formula that evaluates that Last Modified date agaisnt Today(), if over "x" days, then fire off a notification to a specified contact (in another column).

- This seems to work -- however, for some reason, I noted that the date/time stamp on rows are updating 'seemingly' by itself in a manner that the criteria set up would never be met.

When trying to isolate what has changed in that row, it is not apparent. The only thing that comes to mind ... possibly... is that a user altered the view using an established filter view and clicked save? Could that be a reason why a row updates?

I don't believe insertion of rows would / should impact the last modified date, and don't see why applying a filter should update the Last Modified date as no data has changed in that particular row aside from the fact that it may be filtered or not.

Could someone please shed some light on this matter?

Cheers,

Find more posts tagged with

Formulas

Support

Email Notifications

Comments

Mike Wilday

Interesting. Do you have any formulas referencing Today() in the sheet. Because if you did, and they changed the date for any reason, or affected the formula's output it would change the data and then consider that a modification of the data in the row. That might be why you're seeing the modified date change automatically. Have you tried turning on highlight changes in the last 24 hours to see what has changed on each row? That might help pinpoint the issue.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.