Skip to main content

Add days to date depending on selection from a single-select column

M

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

M

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

M

Hi @Mohamed_Swellam


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

Reply


Most helpful members this week

Terms & Conditions