It would be great to be able to reference columns with procedural strings. When you have a large number of columns but with predictable names, this would be very useful. I’ll try to explain the use case for clarity. Let’s say we have these columns. Column 1 Column 2 Column 3 I’d like to be abl…

Reference Column Name with String

Dalmo_Mendonca July 2, 2019, 10:46pm 3

Found this solution using Switch:

Topic		Replies	Views
How to use the result of a formula as a reference?	3	1147	July 3, 2019
How to get column name? (To generate )	10	4885	August 29, 2023
Referencing Column Name from another table	6	2044	August 29, 2023
How to dynamically reference the name of a column and use to select data from a table?	5	1455	May 13, 2024
Formula to add mentions in a string	6	1998	August 4, 2020