Create static date when checkbox is clicked

[pier_bdt]

Hello,

I would like to create a new static date when a checkbox is clicked. It should be [day the checkbox is clicked] + [X Days].

I’m actually using

IF({Follow-up 1 sent?} = 1, (DATEADD(TODAY(),2,"days")),BLANK())

However the Today() function keeps updating the date to … today. I’d like the newly created date to be static and not be incremented every day by the TODAY() function.

Thanks

[ScottWorld · Accepted solution]

Hide your formula field, and then you can automate the process of inserting 2 days from today when the checkbox is checked by inserting the results of your hidden formula field into a normal date field.

[pier_bdt]

Can you clarify “Hide your formula field” plz. Where should I add my formula?

[ScottWorld]

You aren’t actually required to hide it, except for cosmetic purposes. It serves no purpose except to feed the automation, so you don’t need to visually see it. But you do need it for the automation, because automations can’t calculate formulas on their own, so automations have to pull from formula fields that have already been created.

[pier_bdt]

Understood.

I’ve created a new formula field with updated formula but it doesn’t update the date.

IF({Follow-up 1 sent?} = 1, {Date for Follow-Up 2} = (DATEADD(TODAY(),2,"days")), {Date for Follow-Up 2} = BLANK())

[ScottWorld]

You could use your original formula from your original post, but I would scrap that formula and just use the simplest version of what you need, which is this:

DATEADD(TODAY(),2,"days")

Then, hide that formula field because you don’t need to see it.

Then, setup an automation that triggers when you check the checkbox. Set the automation’s action to update your brand new date field (which it doesn’t look like you have created yet) to be the formula field.

[pier_bdt]

Thank you. Its working.