Re: Help with complex IF formula with DATEAD and DATETIME_FORMAT
0
792
0
DATETIME_FORMAT(
DATEADD(
IF(
{Last Invoice Date},
{Last Invoice Date},
{Start}
),
SWITCH(
{Payment Method},
"Quarter", 90,
"Partner", 360,
30
),
'day'
),
'YYYY-MM-DD'
)
That should do it. Since what you want is to check for the presence of any value in {Last Invoice Date}, and change out only its value for another if it fails, all the rest being the same, you want to keep the logic that checks this contained to the smallest scope possible - thus, we make that check inside the DATEADD() function. The IF() statement I used there just checks for a “Truthy” value in {Last Invoice Date} - a “Truthy” value, in this case, is any non-blank value, which will have the effect of evaluating to that very value, the value in {Last Invoice Date}. But if that field is blank, it evaluates as false, and moves on to the false condition, which is the value in {Start}.
I also changed your nested conditional for {Payment Method} to Airtable’s new SWITCH() function, which is a much cleaner and more concise way to express the same thing:
Let me know if it doesn’t work – I didn’t test it out at all, so it’s always possible I made a mistake.
