Dynamically referecing columns in formulas

AmineB

Hello,

My first post here so I apologize in advance if broke Labels/Posting Rules.

I have a column (named Field) that contains other column names. I want to dynamically reference said columns in a formula.

I tried using double brackets: [[Field]] but that won't work.

Is there a special syntax to bypass this ?

patrick_digan

@AmineB Out of the Box the Dynamic Replace is the tool to use for something like this. I've attached an example. I believe there is a Crew Macro if you use those. I also have an idea out there of adding an eval function which would make this much more straightforward.

Community 2020-03-31.yxmd