Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 16, 2021 11:32 AM
This is so simple, and yet no matter what I try, nothing works. :confused:
I want the due date to be 2 days after the creation date. I’ve tried a hundred variations of:
DATEADD({Created},+2,‘days’)
…to no avail. What am I missing??
Solved! Go to Solution.
Dec 16, 2021 06:42 PM
Dec 16, 2021 12:24 PM
get rid of the plus sign. You only need a - if you’re subtracting time, otherwise its just the number.
Dec 16, 2021 04:19 PM
Beet there, tried that…
Dec 16, 2021 05:06 PM
Oh, its your quotes. Curly quotes don’t work in Airtable formulas. Type the quotes directly in the formula bar and they’ll be corrected.
Dec 16, 2021 06:27 PM
Like, a million-bzillion iterations of this formula…
Dec 16, 2021 06:42 PM
And the winning formula is:
DATEADD({First}, 2, ‘days’)
:man_facepalming:t2:
Dec 16, 2021 06:42 PM
Your quotes are still wrong.
DATEADD({First}, 2, 'days')
Dec 16, 2021 06:44 PM
Those are the ones AT uses when I click on Field option, so… :slightly_smiling_face:
And it works!