Select() feature request

Hi everyone,

Is it possible to make SELECT() feature to be able to work with multiple referenced tables? I have many tables from where I’d like to gather values, but the feature itself works only with one referenced table.

I was thinking maybe there would be a possibility to design it in conditional way. For example, if there is value in column of the table 01 with SELECT() feature, it would gather records from table 01, if there is value 02, it’d respectively collect records from table 02 and so on.

If there is mistakes in my technical jargon here, sorry about that. I’m still very new to this.

Thanks

Normally what you’d do is to create 2 Select formulas & add the lists together e.g.

Select(Table1[ColumnA],TRUE)
+
Select(Table2[ColumnA],TRUE)

then maybe use

or

2 Likes