Record date the box is checked

kk

Is there a formula that records the date when the checkbox is checked? I need to track this and right now I just do it manually by right clicking in the cell to see when it was edited. But it would be awesome if I could create a formula to show me when that box was checked automatically.

Paul Newcome

You would need to use either the API or a 3rd party app such as Zapier. There is currently no way to access the cell history or timestamp a specific action (other than row creation). You could always Submit A Product Enhancement Request.

Paul Newcome

You would need to use either the API or a 3rd party app such as Zapier. There is currently no way to access the cell history or timestamp a specific action (other than row creation). You could always Submit A Product Enhancement Request.

Andrée Starå

Hi,

@kk

Smartsheet is working on it.

As Paul mentioned. The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Aubrey K. Rawson

Hi @Andrée Starå ,

Is there a solution in Smartsheet to this?

Thank you,

Aubrey

Paul Newcome

@Aubrey K. Rawson Smartsheet has since released the Record A Date Automation. That should do the trick for you if you are just needing to capture the date a specific action happens.

Andrée Starå

Hi @Aubrey K. Rawson

I hope you're well and safe!

To add to Paul's excellent advice/answer.

This might also be helpful.

Please have a look at my post below with 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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!