Dashboard Metric Breaks on Update of DataShuttle

Joshua Jones

I am sure there is something I am missing. But I try to set a Dashboard Matrix on a field that is refreshed by Data Shuttle. But when the Grid refreshes it breaks the Metric and says Data missing even though there is data in the field.

Is there anyway around this or does Data Shuttle always break a Metric Cell?

Paul Newcome

How exactly is your Data Shuttle set up? If it is set to replace everything in the sheet when it runs, it is deleting the cell being referenced by the widget and then putting new data in new cells.

Paul Newcome

How exactly is your Data Shuttle set up? If it is set to replace everything in the sheet when it runs, it is deleting the cell being referenced by the widget and then putting new data in new cells.

Joshua Jones

Thank you so much

I added an auto incrementing field to my data file and then added it to the Smart Sheet and changed the Shuttle to Replace on Key Field and that worked like a charm!!

Paul Newcome

Happy to help. 👍️