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

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.

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. :wink:

1 Like