Tracking DATE & TIME

Cruz Ortiz

How can we record a date and time in a cell when a condition has been met?

I haven’t been able to record in a cell both, the date and time when certain conditions are met.

Note: The auto-number type column does it automatically every time a new row is added but my sheet has already this type of column being used.

If possible please provide details.

Thanks

Jeff Reisman

There is not yet a function or automation that allows you to record a time, only the Workflow automation to record a date.

By all means, please submit an enhancement request for that functionality on the form link below!

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.196835178.757541251.1598879265-1557598792.1594053397

Jeff Reisman

There is not yet a function or automation that allows you to record a time, only the Workflow automation to record a date.

By all means, please submit an enhancement request for that functionality on the form link below!

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.196835178.757541251.1598879265-1557598792.1594053397

Andrée Starå

Hi @Cruz Ortiz

I hope you're well and safe!

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Cruz Ortiz

Andrée Starå very kind you have shared this with me.

Interesting approach, no doubt.

However, my concerns are:

1. If the Source sheet is changing from multiple fields at the same time, the “Modified” column would provide wrong info to the Destination sheet as it’s changing (is dynamic), I want to trigger the date/time recording ONLY from ONE column (field) change.
2. The “completed time” column in the Source sheet does not record time (hh:mm) but dd/yy
3. Please note I am already using the autogenerated "Created" field in my sheet and when I mimic your approach it transfers the Created date&time to the destination sheet. In the end I need to calculate the differential between the creation date&time and cell change date&time (hh:mm).

If you or somebody can bring some light to my concerns or if there is an alternate way that would be greatly appreciated if it's shared with us. 

Thanks

Andrée Starå

@Cruz Ortiz

Happy to help!

Please have a look at the solution again. I noticed an error, but now it's working again.

It's not dynamic, it registers the time when it's copied over, but it can probably be modified to work for your need.