Use column title in a formula

[Rickard_Abraham]

Yep that’s pretty clean @actualinfo!

I’m trying to connect all posts like this to my suggestion 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…