I am creating a new column in my script and would like to populate the column by a simple formula. Instead of referencing by name, I would like to reference by column number in the formula because the column name will change depending on the work week, but it will always be the same column number.
dt<<New Column("New", formula(:Goal - :Column Name(36)));
The above expression does not work, but should give the gist of what I am trying to do.
Could not find any info on how to reference a column by number in the formula.