Smartsheet report cell linking not working
I am trying to edit a Smartsheet report to update a dashboard and cannot get the content to populate. I linked the correct cells into a summary sheet called Portfolio and the data is populating correctly. But when I go to pull in a specific column data from Portfolio to the report sheet called Report, the column does appear but the content does not. It shows that it is linked to the correct cell though. I also tried removing and re-adding the filters to see if that could be why and it still won’t populate the data in the cell even though it is linked correctly. I also tried creating a new report and when I add in that column it still does not contain the data. This report ties to the Portfolio Dashboard and I need that specific column cell content to appear. Right now, only the column title is showing up but the cells are empty.
Any help would be greatly appreciated!
Is it possible you could be linking the report to a sheet with the same (or similar) name that happens to be blank?