'Is there a way to build a dashboard in google sheets that draws from multiple sheets?
I'm trying to design an interactive dashboard in Google sheets that will draw information from 3 sheets(These multiple sheets represents 3 different sales call). The 3 sheets have similar data. I want to compare the columns in each sheet that ranks sales calls. So that I can have a line chart that shows the rankings on the 3 different sales call. I have tried using an array function to draw data from the different sales call sheets to another sheet, so that I can insert a pivot table. So far, I haven't been able to achieve my goal. What else can I try?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|