Why do my Index Match fields not show the results on Reports?

BFuller

I have some reports from a sheet that populates a few fields from an index/match formula. On my report, the data doesn't come through. It shows #INVALID REF even though the data is correct on the Smartsheet. Also, it seems like the report isn't updating when those fields on the Smartsheet are updated. I have some other fields that reference a master customer list. When the customer isn't included in the original list I have to update it and then amend the sheet so it all populates. It works fine, except in the reports. Any ideas?

Paul Newcome

You may want to reach out to Support for this one. Reports do not have their own cross sheet references. They are supposed to just be pulling directly from the sheet(s).

Paul Newcome

You may want to reach out to Support for this one. Reports do not have their own cross sheet references. They are supposed to just be pulling directly from the sheet(s).

BFuller

@Paul Newcome thank you!!

wallacea

https://community.smartsheet.com/discussion/comment/347667#Comment_347667

It's been a couple years since this question has been asked - has this changed?

Paul Newcome

@wallacea Exactly what problem are you running into?