Can we combine 2 things in an “IF” statement using “AND” or “&”?
For example, what if we wanted to compare 2 different sets of date fields. In other words, if I was using plain English, I would want to say something like this:
IF ( IS_AFTER({Event Start Date}, {Location Start Date}) AND IS_BEFORE ({Event End Date}, {Location End Date}), "Yes", "No" )
or I would want to say something like this:
IF( {Event Start Date} > {Location Start Date} AND {Event End Date} < {Location End Date}, "Yes", "No"
I know that both of those formulas are invalid formulas, but I’d love to say something like that in Airtable, using Airtable’s syntax.
Thanks!