Dynamic Column

AppSheet AppSheet Q&A
1

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]
)
)
)

2

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 :open_mouth:

Simon@1minManager.com

2 Likes
3

SWITCH() - AppSheet Help

1 Like
4

Thank you guys @1minManager @Steve

I edit my table structure in order to get working

1 Like