Capture Date and Time when column is changed

Hello everyone!

I want to know if there is anyway to capture the date and time using if function, when a column value is changed to "Approved"

Let's say I have two columns as follows:

Status Time

Approved if ( [Status]@row = "Approved", Today() AND Time(), 0)

is it possible to achieve this in smartsheet?

Thanks !!

Find more posts tagged with

functionality

Accepted answers

All comments

Paul Newcome

It is not possible that way.

You can use this method I developed to capture the date/timestamp and then use an INDEX/MATCH to bring it back to your working sheet.

=IFERROR(INDEX({Copy Sheet Modified Column}, MATCH(ID@row, {Copy Sheet ID Column}, 0)) + "", "")

https://community.smartsheet.com/discussion/63561/date-time-stamp-option

Andrée Starå

Hi @Mashael

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

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 week!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

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.