Get column names with “X” for today’s row in table

[Rickard_Abraham]

Hey @Elaina_Kreher!

@anon1959570 is right, it seems like you should change your data model. There’s also lots of relevant reading here:

New formulas for columns

Goal Dynamically select a column from a table Issue The current possible approach forces you to repeat yourself into a coupled mess: Select Options Formula List("Population", "Area", "Density", "GDP", "Elevation", "Temp") Dynamic Column Formula Switch( [Select], "Population", thisRow.Population, "Area", thisRow.Area, "Density", thisRow.Density, "GDP", thisRow.GDP, "Elevation", thisRow.Elevation, "Temp", thisRow.Temp ) If you want to add a column you need to modify informati…