I have a grid sheet that contains contact information. I am trying to pull that information into a dashboard focused on specific staff. The plan was to use a metric widget to pull the contact information for that individual (i.e., Name, Phone Number, Email, etc.).
When I add a metric widget and try to link to this grid, I select the metric widget, select the grid sheet, then click the cells and click ok… but the screen then goes back to the dashboard and nothing has been added to the widget. It still tells me to add data.
I tried to put the data in a sheet summary on that sheet and add it, but got the same results.
I tried to pull data from cells in other grid sheets, and it worked fine.
thoughts or ideas?