Question on ChangeTimestamp. I have it set u...

(Tammi Canelli) #1

Question on ChangeTimestamp.

I have it set up and it’s working correctly, tied to a “last updated” date field.

but i notice a change on the same day gets me nothing.

We will have people updating status for certain items multiple times a time but only want to capture the most recent date/time updated.

What’s the best way to do this?

(Grant Stead) #2

Curious, how are you calculating, last updated… Also you should change your last updated to a datetime format. (If you need date elsewhere your can use the new DATE () explain, or out or in a virtual column.

(Tammi Canelli) #3

It’s just a date field, where user would manually set date then changetimestamp would update.

obviously not right.

so i tried adding a behavior to update it.

Do i need to set an action that clears the date first?

(Aleksi Alkio) #4

The Change timestamp won’t update because it’s a date field. It will update it only if the column’s value is changed.

(Grant Stead) #5

@Aleksi_Alkio I think that if you have a change timestamp, and you don’t point it to any column, and put no conditions, it’ll update to show the most recent edit?

(Grant Stead) #6 - Tracking Changes Using ‘Change’ Column Types Tracking Changes Using ‘Change’ Column Types

(Steven Coile) #7

@Tammi_Canelli, what exactly are you trying to accomplish?

If you want the timestamp for any change to the row, don’t tie the ChangeTimestamp column to any field. With no columns specified, it’ll update if any column changes.

Myself, I don’t use the ChangeTimestamp column type to track row edits; instead, I create a simple DateTime (normal, not virtual) column with an App formula of =now(). This column is set anew each time the row is modified.

(Aleksi Alkio) #8

@Grant_Stead I assume that the date field is the only column for that Change Timestamp field.

(Tammi Canelli) #9

Thank you everyone.

We have to report on certain information elements when activated and depending on level of activation the updates could happen 4 to 6 times in a 24hr period.

The sheet that was setup is tied to a dashboard in smartsheet with just one date col and one time col for last updated.

I will remove the connection to the date col and see if that works.

(Tony Fader) #10

@Tammi_Canelli This example app might be helpful for you: - Change Columns - Keep track of when columns change Change Columns - Keep track of when columns change