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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!