Sign in to join the conversation:
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?RegardsStuart
Try this:
=IF(SNAGS1 = true, TODAY(), "")
If you uncheck the box, the date will be cleared.
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
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!
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
I need a formula that looks for the a specific person in the Ball In Court column, then look at specific status in the Comment Status column and then look at another column and if it is blank return the number. I am not sure on what this should look like for the last column.
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
