VLOOKUP to another sheet - cannot pull these fields into a report, getting #ERROR
I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns.
I'm seeing an issue where the report can only successfully pull data in sometimes. Sometimes I open the report and my data is there - which is great! However, sometimes I open it and I just see #ERROR in all of the columns that are using the VLOOKUP to another sheet. I can't give this to my team as a usable tool if it only works half of the time.
Is this a known bug/issue that's being worked on?
If I can't pull those cross-sheet VLOOKUP fields into my reports, it really renders the cross-sheet VLOOKUP functionality useless for me since reports are the primary way my team interacts with the SmartSheet data. Hoping there's a solution for this.
Help Article Resources
Check out the Formula Handbook template!