I've been trying to use a cross-sheet reference to combine columns from my source sheet into one column on my destination sheet. However, I can not even pull information from one of my cross references.
This is the code I've been using.
=INDEX({Job Book Job Number}, @row)
It keeps giving me #unparseable
If I use that formula string in the source sheet in a separate column, it works. However, it does not work in sheet reference. What may I be doing wrong?
