Capturing Date of Transaction

mlynch65996

Greetings,

I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer".  I tried modified date but that field gets changed too often to accurately reflect the state.  Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's history.

Mike 

Paul.Koetke

Hello,

You can track when a cell was changed by using the Cell History function. However, there is no way to display this time stamp in a cell. What I would recommend instead would be to have a "Picked Up by Customer" date column. When the pickup is completed, you just select todays date instead of using the dropdown to show that it was picked up. 

Let me know if this will work, otherwise happy to brainstorm different solutions. 

Paul Koetke

Upwork - Smartsheet Consultant

Andrée Starå

Hi Mike,

It's possible to do it with the help of a service like Zapier or similar. 

Would that work?

I hope this helps you!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting