Hi All,
Was hoping to get some input on the formula below:
IF({D-Phase Status} = “D1 - Concept”, DATEADD(TODAY(), 30, ‘days’), TODAY())
I am trying to put together a formula which will add 30 days to today’s date if D1- Concept is chosen in the single select menu of the D-Phase Status column otherwise, just to display today’s date. I can’t quite work out why the formula isn’t working and would really appreciate your help.
Thanks in advance
Hi @Michael_Day,
Welcome to Airtable Community ! :grinning_face_with_big_eyes:
The formula works fine for me, im assuming you are not using the curly quotation and using the straight ones?
IF({D-Phase Status} = "D1 - Concept", DATEADD(TODAY(), 30, 'days'), TODAY())
BR,
Mo
I was using the curly brackets - those were the ones that Airtable adds automatically if you click the name of a column from the formula menu when typing it out.
However, I literally just re-entered the formula and now it works - zero changes!? So confusing
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.