date stamp for checked column

txsteve18

I am looking for a way to date stamp a check in a column. I have employees who conduct monthly inventories of tool kits and would like to show that they are doing them on time. I have this set up with a column for each month after the kit and individual tools are populated in rows. I would like them to be able to check each tool as they inventory (or scan a QR code with their phone attached to each tool to check the box) and have the column next to the month date time stamped. As of now the next row just turns green, but there is no way to prove that I didn't check all the boxes for the year yesterday. Thank you for any ideas.

 

Steve

Andrée Starå

Hi Steve,

The third-party service/integration Zapier is an excellent option for this scenario. Is that an option for you?

Another workaround would be to structure the solution differently and automatically lock rows after they checked the box.

Would that work/help?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Depending on your specific need, you could also use the Cell History function that shows history on each cell.

More info: https://help.smartsheet.com/articles/518314-viewing-cell-history

Hope that helps!

txsteve18

I am just exploring the possibilities with smartsheet now. I don't think I will be trying to integrate other things as of now.

The Second may work although it is a little hard to lay this out in my head in a way that is user-friendly. I may have to play with it a bit.

 

Steve

txsteve18

I tried viewing the cell history of the cell set to turn green with the check on the previous cell. It did not give me much. I didn't look at the cell that has the checkbox. May dig into that a bit.

 

 

Thanks, Steve

Andrée Starå

Ok.

Let me know if you have any questions!

Andrée Starå

You'd need to check the cell with the checkbox.

I might have another idea. I'll get back to this post if it works out.

Mike Wilday

We've tried similar processes but determined to have the employee input the dates that completed something rather than check the box. I know timestamps are something that Smartsheet has mentioned as a possibility in the future, but there is no roadmap for us to review. I recommend submitting a product enhancement request. 

zbellm

bumping this thread. I need something similar. When one box checks, another cell date stamps when the box was checked. I need to make approvals for my team quick and easy (check box) but have the associated date stamp history hidden, but accessible for back-end reporting. I do not want to have to manually reference cell history or produce an automation that seperately captures the date stamp info. I just want a formula or logic that captures date stamp of associated check boxes in specified cells.

Possible here in 2024 with Smartsheet?

Andrée Starå

Hi @zbellm

I hope you're well and safe!

Here's something that might help until it's possible with a formula.

Please have a 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 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!