Why do my Index Match fields not show the results on Reports?
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?
Best Answer
-
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).
Answers
-
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 thank you!!
-
It's been a couple years since this question has been asked - has this changed?
-
@wallacea Exactly what problem are you running into?
Help Article Resources
Categories
Check out the Formula Handbook template!