# Create static date when checkbox is clicked

Topic Labels: Formulas
Solved
2178 6
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
18 - Pluto

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.

6 Replies 6
18 - Pluto

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.

5 - Automation Enthusiast

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

18 - Pluto

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.

5 - Automation Enthusiast

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())
``````

18 - Pluto

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.

5 - Automation Enthusiast

Thank you. Its working.