Dynamic Column

[abood89]

Hello

I have a table with many columns that I would like to get sum for each column by chosing which column to sum.

I made another table with name filters and I put some columns data to be used as a filter on first table. 

My question is , is it possible to use dynamic column name from other table in this expression 

SUM(
SELECT(
First table[column name],
AND(
(EOMONTH(TODAY(),-1))<[Date],
(EOMONTH(TODAY(), 0) + 1)>[Date]
)
)
)

[1minManager]

Nope you can't have dynamic column name.  I have a data table where depending on a condition I have to pick a particular column.  So my formula is loosly:

IFS(

[This]="abc", Select(SUM([Column A],TRUE))

[This]="xyz", Select(SUM([Column B],TRUE))

)

PITA, especially when theres 70 columns 😮

Simon@1minManager.com

[Steve]

SWITCH() - AppSheet Help

[abood89]

Thank you guys @1minManager  @Steve  

I edit my table structure in order to get working