Workaround for Cell-linking to a Report
I have a single survey with many questions.
Stakeholders are asking that I breakdown the data into multiple dashboards (managed, franchised, virtual training, in-person training)
My plan was to have a Report filter for each required type from the response bank (managed, franchised, virtual training, in-person training). Then, create a metrics page for each type and create the dashboard from there.
Problem is, I can't do cell linking to fill the metrics pages from the reports because reports can't link cells. I tried setting up an additional sheet and filtering the data on the sheet, but the formula I'm using doesn't know how to filter and count.
What workarounds work for all of you?
Best Answer
-
You need to build the Metrics sheet pulling all the data there then use the metric widgets to display the data in the dashboard.
Another solution could be using the report widget to display the report data but all the information will be displayed in a report format.
Answers
-
You need to build the Metrics sheet pulling all the data there then use the metric widgets to display the data in the dashboard.
Another solution could be using the report widget to display the report data but all the information will be displayed in a report format.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives