What does your current formula look like?
What does your current formula look like?
Go easy on me… I’m an AirTable NOOB. This formula is only a couple in line as I was testing the string, but I always had NaN return as the output data.

Go easy on me… I’m an AirTable NOOB. This formula is only a couple in line as I was testing the string, but I always had NaN return as the output data.

Hey @Matt_Gorman - the problem is that you are trying to do math with the output of a Date field. Airtable’s formula syntax doesn’t allow you to just add a number to a date like that. So it’s complaining at you and saying “NaN”, or “Not a Number”, to let you know that it doesn’t know what to add 21
to.
You can use the DATEADD()
function to add days to a date, though, and you can also use a SWITCH()
function to make your formula a little more concise and readable:
SWITCH(
{Contact Cycle},
"3 Weeks", DATEADD({Date Contacted}, 21, 'days'),
"6 Weeks", DATEADD({Date Contacted}, 18, 'days')
)
Go easy on me… I’m an AirTable NOOB. This formula is only a couple in line as I was testing the string, but I always had NaN return as the output data.

Lol! We would never be harsh on you!
I see that @Jeremy_Oglesby has already responded to you!
The thing you were missing is that you need to use the DATE_ADD
function, as Jeremy pointed out.
And you can use either SWITCH
or a nested IF
statement — both would work.
Hey @Matt_Gorman - the problem is that you are trying to do math with the output of a Date field. Airtable’s formula syntax doesn’t allow you to just add a number to a date like that. So it’s complaining at you and saying “NaN”, or “Not a Number”, to let you know that it doesn’t know what to add 21
to.
You can use the DATEADD()
function to add days to a date, though, and you can also use a SWITCH()
function to make your formula a little more concise and readable:
SWITCH(
{Contact Cycle},
"3 Weeks", DATEADD({Date Contacted}, 21, 'days'),
"6 Weeks", DATEADD({Date Contacted}, 18, 'days')
)
@Jeremy_Oglesby Thank you for your help with this. I’ve enjoyed learning AirTable! Now as I typed it out and add the additional cycles into the code it’s working beautifully!
Lol! We would never be harsh on you!
I see that @Jeremy_Oglesby has already responded to you!
The thing you were missing is that you need to use the DATE_ADD
function, as Jeremy pointed out.
And you can use either SWITCH
or a nested IF
statement — both would work.
@ScottWorld I appreciate the kindness! :grinning_face_with_big_eyes: I’m going to keep practicing, asking questions, and learning in order to improve. I appreciate the response!