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.