Get Date and Time from a column

Peterson

I have a spreadsheet, which contains a Check Box type column, when it is selected I needed to save the date and time in another column for SLA, I've tried different ways and none of them work, I thought about copying the line and getting it the modified column, but the problem is that it keeps updating, does anyone know how to do this? Thanks.

Purnima Gore_PGPS

Hi @Peterson

The automation will work for this.

Go to Automation then use When rows are changed and use the Column where the checkbox e.g Checkbox is checked, record a date in the SLA column. That will record the date when you check the checkbox.

Thanks

@Purnima Gore_PGPS

Peterson

Yes, it really works that way! However, the problem is that I necessarily need the hour and minute, so automation no longer solves it.

Andrée Starå

Get Date and Time from a column

Peterson

Jul 4, 2024

I have a spreadsheet, which contains a Check Box type column, when it is selected I needed to save the date and time in another column for SLA, I've tried different ways and none of them work, I thought about copying the line and getting it the modified column, but the problem is that it keeps updating, does anyone know how to do this? Thanks.

---

View Post

Hi,

I hope you're well and safe!

Please look at my post below, which contains a method I developed.

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

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Peterson

Hi Andrée, it didn't work, because when I bring the creation date through automation, even when I create a field like "created in" in the destination spreadsheet, the date created in the source spreadsheet comes up, how could I get around this?

Andrée Starå

https://community.smartsheet.com/discussion/comment/443614#Comment_443614

I'd be happy to share an example.

Please email me at andree@workbold.com, and I'll share it with you.

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!