Creating a column name via a variable....then calling on the column name, as a variable, in a formula...
Mar 31, 2016 3:54 PM(2322 views)
I hope my subject isn't too confusing. I'm a .jsl rookie but I have a small project I'm trying to learn on. I am stumped on this, and not sure why it pastes in this sheet like this
I'm creating a column name via the variable dsocket which is a concatenated "d" and a row/cell from another table. The column is created normally.
Then the formula needs to reference the very same new column name but I'm currently using the same variable (see the end of the formula). The problem is that it appears that I'm not formatting it right when referencing the column name in the formula because instead of a :column name I am not getting the semi-colon in front. I've tried concatenating a : to the variable but the output is ":column name" in quotes and I just need :column name.....make sense?
Any ideas how to resolve this? I'm hoping I've overcomplicated it. Thanks!