Formulas in Airtable can be as simple or as complex as you need them to be. When writing a formula with many conditions it can get particularly difficult. You may have run into the case yourself where you have written a complex formula and somewhere ...
You could try using a Rollup field instead of a Lookup. Rollups work similarly to Lookups, but in a Rollup at the bottom of the field configuration, you are able to add formulas (some of which it will give you examples of) in order to manipulate what...
I’m sincerely interested to learn how you think the formula could be improved upon. As a simple technique to combine many formulas into one, I see this as being the most simple to understand. It may not, admittedly, be the best example I could have g...
If you’re looking for the word “data” somewhere in a field, why not remove “the” from the FIND() formula and look only for “data”? That way you’ll pick up anywhere where that word occurs, regardless of what else might be in the string.
FIND("data",LO...
