3

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  

Functionality
Department

Comments

Try this:

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

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

Andree_Stara

In reply to by leejoramo

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

Andree_Stara

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