IF formula not working to pull data from two columns

[Valerie_Martin]

This formula is not working to pull data from the two formula columns (Days Actually Out and Backdata days out) I want. It seems so simple. If the DATE OUT is before or is today, pull this number. If the date is AFTER today, pull another.

IF({Date Out} <= TODAY(), {Days Actually Out}, IF({Date Out} > TODAY(), {Backdata days out}))

It currently only pulls the ‘Backdata days out’ data for this column. . . Can anyone tell me if this is a no-no in AirTable or if I’m doing something wrong?

[PC1]

Not sure if this is your issue but here is a link to a similar problem I had. It was suggested (and worked) to add AND.

Second "IF" in nested statement returning no result Formulas

Hello, my first post to this community. This formula was entered and accepted with no errors. The issue is the second IF (in this case {Tax Type}='Sales Tax) does not produce a result. Here is the formula: IF({Tax Type}=‘Bank Rec’,IF({Qtr}=1,‘1/31’,IF({Tax Type}=‘Sales Tax’,IF({Qtr}=2,‘3/20’)))) My statement is: Statement 1: if the tax type is ‘Bank Rec’ and the Qtr=1 then the date 1/31 should display. Statement 2: if the tax type is ‘Sales Tax’ and the Qtr=2 then the date 3/20 should disp…

[AlliAlosa]

Is {Date Out} a date field? If not, that could be the source of your problems.

I actually didn’t realize that Airtable supports logical operators in comparing dates, but it appears they do. I tested your formula and it worked for me (but if {Date Out} is not a date field, it will produce wonky results).

I would say it’s probably better practice, though, to change your logical operators to date time functions like IS_BEFORE(), IS_SAME(), and IS_AFTER().

Try the following:

IF({Date Out}, IF(OR(IS_SAME({Date Out}, TODAY()), IS_BEFORE({Date Out}, TODAY())), {Days Actually Out}, {Backdata days out}))