This is my first post to the community. I’ve seen other posts similar to this topic, but they don’t quite address what I’m trying to achieve.
I’m having an issue with a nested IF statement and not sure whether a combination SWITCH/IF would be best for this formula.
I have two columns - column 1 (Date) and column 2 (Location) that is single select. I want a third column (Status) that returns a value based on what is populated in the first two.
Logical Argument 1: If column 1 (Date) is not blank OR column 2 (Location) is ‘Outside Area’, the Status column should return “Yes”.
Logical Argument 2: If column 1 (Date) is blank the Status column should return “No”.
Hi @ScottWorld, I got the formula to work in my test table, but had trouble making it work in my production environment. The concept is the same, but the column names are different, which I wouldn’t think would make a difference as long as they are updated. I figured it out though, someone had entered a space after the text in the single select text option. Is there a way to add a wildcard/like operator to the = text area?
I noticed that this part of your follow-up wasn’t answered. Airtable doesn’t currently support wildcards or other means of pattern matching (i.e. regular expressions). The closest it has are the FIND() and SEARCH() functions, either of which would work in your situation. Here’s the updated formula using FIND():
This also adds the ever-so-slight optimization of removing unnecessary curly braces from around the field names. Curly braces are not required for single-word field names, as long as they don’t contain special characters. A field name that’s only numbers, or one that contains spaces or special characters, will require braces around it in your formulas.