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.