So I feel like the Airtable formula support is severely lacking in a couple of ways, but here’s a really painfully obvious one:
Let’s say you have a single base, single table, and there are two columns:
Current Members and
Current Members column contains a comma-separated list of current members, like
Valid Members column contains a comma-separated list of ALL allowed members, like
Bob, Susan, Tim, Jim
Now, I want to create a third, formula-powered column called
Are Current Members Valid? and that will return
1 if all
Current Members are present in the
Valid Members column;
0 will get set otherwise.
In order to implement this correctly, I sort of need to:
Current Membersitem as an array – which means I need some sort of
SPLIT()formula that will split a string by each comma into a string array
Iterate over each item in the string array and check to see if each item is present in the
Because no Airtable functions exist that can do either 1 or 2, I’m forced to have to implement something far more complicated as a script automation, which makes this way more complicated than need be.
This use case doesn’t seem that unique – in fact, this use case seems to be pretty common.
Am I missing something here, though?