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å

https://community.smartsheet.com/discussion/124221/get-date-and-time-from-a-column

Hi,

I hope you're well and safe!

Please look at my post below, which contains 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 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!