Insert Time Stamp

Marie Eastman

Is there a way to insert a timestamp into smartsheet when a specific field has updated? I would create a column that it can be stored in I just don't want to have to have the team manually update it. I need to be able to see what was completed yesterday. 

 

thanks

J. Craig Williams

Marie,

 

You can try to use the Modified Date field for that, but it shows row changes, not cell changes.

 

Here's a post I wrote on how to do this in Zapier (www.zapier.com)

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

 

It can also be done using the API.

 

Craig

 

 

 

Colin Entrekin

Please give us a timestamp formula.  Thanks!