How to dynamically reference the name of a column and use to select data from a table?

#1

Searched everywhere and cannot find a solution for this …

I have a table with columns named by date, such as JAN 10, JAN 20, JAN 30.

If today is JAN 10, then I want to grab data from the column JAN 10.

I use a formula with function Today() to build the string “JAN 10” and I name the formula myColumnName but I cannot figure out how to use myColumnName to grab data from the table.

I’ve tried TableName.myColumnName and a variety of formats, but can’t get it to work.

Any suggestions?

#2

hi @Mathew_Georghiou , welcome!

As far as I know the table name and the table column should be defined manually and via formulas you can work with row information. You cannot filter on columns with something like SelectColumns(tableName, if(name=“whatever”, selectColumn, ‘something if not’))

sorry, best, christiaan

Sorry best Christiaan

2 Likes