Auto/number - date on particular cell, not whole row

Maxime Vanwynsberghe

I'm trying to find a way how to populate a datestamp in a cell based on the last change from an another  cell in a particular column

 

fe:

Row 1 - column A: dropdown (Start, pending, stop)

Row 1 - Column B: I want the date when Status changed on column A

 

Auto/number - date: works, but it looks at every cell on that row, i want it to look within one particular cell.

 

Thanks

 

Maxime

 

 

Alison

Hello Maxime,

Thank you for contacting Smartsheet Support.  

At this time, Smartsheet does not support this functionality to create a timestamp except via our Modified (Date) or Created (Date) System columns as you'd mentioned; however, I've let our Product team know about your request.

Due to the large number of variables they have to consider when choosing what to develop next, we can't confirm when or if this will be built, but we have let them know.

You can also let our team know about your interest via the "Submit Product Enhancement Request" under the "Quick Links" section on the right-hand side of this page.

Kind Regards,

Alison

Smartsheet Support

Chris.Opland

I am now looking for this feature as well.  I would like a time stamp for when a the task was assigned and when the task was completed.  So, a time stamp when Column Assigned to was created, and a time stamp when Column Status was changed to COMPLETE.

Thank you,

Christopher Opland

Andrée Starå

Hi Chris,

You could probably use a third-party service like Zapier to set it up.

Is that an option?

Also, Please submit an Enhancement Request when you have a moment.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting