if checkbox

Stuart.d

HI, 



If a checkbox is selected in column "SNAGS" can another column "DATE RECORDED" automatically populate the date in which the checkbox field was selected?



Regards

Stuart  

Lee Joramo

Try this:

=IF(SNAGS1 = true, TODAY(), "")

If you uncheck the box, the date will be cleared.

Andrée Starå

Unfortunately, that won't probably work because the TODAY will update to the present day.

The only way that I can see that it would work will be if you change the date manually to the date on that day.

Best,

Andrée

Andrée Starå

Hi again Stuart,

It's possible to set up with the help of a service like Zapier, Azuqua or similar. Depending on your specific use case the question is if it's worth it.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting