timestamp column that will show DATE last updated and a ENTERED DATE

Jlind

I would like to include two columns with those dates

Genevieve P.

Hi @Jlind

Have you taken a look at the System Columns in Smartsheet? You can add a "Created" Date column and a "Modified" Date column to your sheet to track exactly those two items: when a row was entered/created, and when the rows was last updated.

See: Use a System Column to Automatically Add Information to a Row

Cheers!

Genevieve

Genevieve P.

Hi @Jlind

Have you taken a look at the System Columns in Smartsheet? You can add a "Created" Date column and a "Modified" Date column to your sheet to track exactly those two items: when a row was entered/created, and when the rows was last updated.

See: Use a System Column to Automatically Add Information to a Row

Cheers!

Genevieve

Jlind

Thank you @Genevieve P.

sflanag1

@Genevieve P. is there a way to populate a column with the date a specific cell was last edited?

Use case: We have a % completed column; I want to know when this was last updated. If someone makes a change to another column, then I wouldn't want that to effect the "last updated column". Is this an enhancement request?

Genevieve P.

Hi @sflanag1

If you don't need the time, you could use a Record a Date workflow - this will record the date based on a specific trigger (e.g. that one column changes).

Here's more information!

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action

Cheers,

Genevieve

sflanag1

This is great! Thanks @Genevieve P. !