Use a value from a row as a column name in a formula

[Austin]

I was to be able to take a table named Filter and use the value from columns to build formulas in a slice filter.So if my table looks like:
Column Name
Relation
Value

I want to use these values in a slice filter to AND() all of these together.
so it would look like:
AND(
Column Name (use a switch/virtual column to get the symbol that is used by Relation) Value
…
)
Is this too ambitious of a feature? My current Filter table just uses a pre-filled set of columns that I let my users filter based on then they can use the search from there to narrow it down more.

[Steve · Accepted solution]

What you want to do is well outside AppSheet’s capabilities.

You cannot use a column value as the name of a column in an expression.

You cannot “use a switch/virtual column to get the symbol that is used by Relation”.

You’ve gotten a little too advanced.