How can I use cross sheet reference to combine columns from the source sheet into destination?

bryan.krusch

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?

Andrée Starå

https://community.smartsheet.com/discussion/133848/how-can-i-use-cross-sheet-reference-to-combine-columns-from-the-source-sheet-into-destination

Hi,

I hope you're well and safe!

You can't have @row in the formula. Should that reference a specific row?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!