Status Column Change to Record Date of Change

tim.curtin

Hello,

I am developing metrics for a group at my company and need some help. They do not log when they mark something as complete by date just by status. The date of the status change is in the cell history but I was wondering if there was a way to write a formula to show when a status is set to completed it records the date in a separate column. Does anyone have any experience with a formula like this? I am not sure where to start.

Thank you!

Tim

Matt Johnson

Hi @tim.curtin

The "Record a Date" feature is found within the Automation tab. First add a date column to your sheet and then go "Create Workflow from Template", scroll to the bottom and choose "Record the date when specificed criteria are met". It will explain what it does. From there the options are pretty straight forward. Let me know if you have any questions.

Thanks,

Matt

Matt Johnson

Hi @tim.curtin

The "Record a Date" feature is found within the Automation tab. First add a date column to your sheet and then go "Create Workflow from Template", scroll to the bottom and choose "Record the date when specificed criteria are met". It will explain what it does. From there the options are pretty straight forward. Let me know if you have any questions.

Thanks,

Matt

Andrée Starå

Hi @tim.curtin

I hope you're well and safe!

To add to Matt's excellent advice/answer.

If you need to store the time too, you can use my method described below.

More info: 

Lock or Store Date/Value Solution without using Zapier

Andrée Starå

May 24, 2020

Hi all,

I hope you're well and safe!

I've developed a solution that lets you store the date or value.

You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.

We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id/value that we can use, it will work.

Also, this opens up more options with auto-numbering and similar.

Depending on other workflows, you could reuse one sheet for multiple workflows.

I hope that helps!

Let me know if you have any questions!

Stay safe and have a fantastic day!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as helpful. It will make it easier for others to find a solution.

---

View Post

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!

HRich

Hi All

Does the "record a date" automation always enter the date in US timezone as it is putting the date as yesterday for me in Australia?

Thanks

HR