Is there a way to timestamp using a formula?

AimeeRH

Apologies if this has been asked previously, I am wondering if there is a formula (or any other method) that can be used that can add a timestamp into a cell for when the workflow was triggered.

For example, I have a workflow that sends an email to person 1 and i would like the date and time in a cell that this was sent to person 1

Thank you in advance! 😊

Paul Newcome

@Paul Rosas Try specifying an exact match by dropping a zero into the third portion of the MATCH function.

MATCH([Column Name]@row, {Range}, 0)

Paul Newcome

You won't be able to use a formula to timestamp a workflow, but you can leverage the modified (date) type column to timestamp based on the same trigger as your workflow.

You would use the method below to capture the time stamp and then an INDEX/MATCH to pull the timestamp back onto the working sheet.

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

Paul Rosas

@Paul Newcome

Paul,

Whenever I followed your instructions here, I ran into an issue:

The column on my main page (cutting completed timestamp) that I input the INDEX/MATCH formula into to pull the timestamp over into my main page doesn't actually show it as a timestamp. The most I can get is the date (if i categorize the column as a "date" column), but I need the whole time stamp as well. I believe it's because of the type of column. Also, whenever I turn it into a "Modified Date" column, it doesn't let me input any formula.

Keep in mind that the column I have in the sheet that I'm trying to reference (the one containing the copied over rows from the automation) is a Modified Date column.

Please help!

Paul Newcome

@Paul Rosas You are going to need to modify the INDEX/MATCH to pull in as a text string and have it placed in a text/number type column.

=INDEX(........, MATCH(.......)) + ""

Adding "plus quote quote" to the end of the formula will convert it into a text string and should pull over everything as needed.

Paul Rosas

@Paul Newcome

Thank you for that!

I'm now experiencing another issue. Although my sheet that contains my copied rows from the automation trigger only has three rows that I've checked off, my main sheet formula (cutting completion timestamp column on bottom photo) returns a bunch of times, even though there is no matches. As you can see, my reference sheet only has 3 SO#'s to match to, even though my main sheet is pulling all kinds. And i've triple checked to make sure there aren't copied rows at the bottom that I was unaware of, also that each SO# on my sheets are unique to those specific rows.

I've also attached my formula. Please help.

Paul Newcome

@Paul Rosas Try specifying an exact match by dropping a zero into the third portion of the MATCH function.

MATCH([Column Name]@row, {Range}, 0)

Paul Rosas

@Paul Newcome

That absolutely worked! Thank you for the help, sir!

Paul Newcome

Happy to help. 👍️