hello everyone, i have a 3 diferend data (tables in airtable) data1, data2, data3.In each table (data) contains information about categories that are identical to each other (data1 - “sport”, data2 “sport”, data3 “sport”). Now I need a formula that will look in each of those 3 tables to see if it contains this category “sport” and show it in one place (like list of sport…)
How to combain this formulas togehter? or maybe i’m going about it completely wrong!
Can anyone help me please set up the formula?