Tracking DATE & TIME

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

Find more posts tagged with

Accepted answers

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

All comments

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:

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.
The “completed time” column in the Source sheet does not record time (hh:mm) but dd/yy
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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.