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.
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’))
It would be useful to just Display the column name in a formula.
Something like this, that returns a string, that is the name of the column.
(Coda AI actually tells you this is possible!)
= TableX.Column 1.Name()