Automation confusion

[Real_Live_Enter]

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??

[Kamille_Parks]

get rid of the plus sign. You only need a - if you’re subtracting time, otherwise its just the number.

[Real_Live_Enter]

Beet there, tried that…

[Kamille_Parks]

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.

[Real_Live_Enter]

Like, a million-bzillion iterations of this formula…

[Real_Live_Enter · Accepted solution]

And the winning formula is:
DATEADD({First}, 2, ‘days’)

:man_facepalming:t2:

[Kamille_Parks]

Your quotes are still wrong.

DATEADD({First}, 2, 'days')

[Real_Live_Enter]

Those are the ones AT uses when I click on Field option, so… :slightly_smiling_face:
And it works!