if checkbox

if checkbox

Stuart.dStuart.d
edited 12/09/19 in Formulas and Functions

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  

Comments

  • Try this:

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

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

  • Andrée Starå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

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Andrée Starå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

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.