Connect To Sheets – Pulse Dashboard
How to get data from other sheets
To pull data from other spreadsheets, use the IMPORTRANGE function.
The Process
If you use the same date range choices in the same columns for every sheet, then pulling in data to your Dashboard is easy.
Choose the row of data you want to import from another sheet.
Set up the IMPORTRANGE function in the far left date range, say Last 7 Days. Verify that it is grabbing the correct data.
Now copy it across your entire sheet until you come to your last date range.
Tips
1. Do all your calculations on other sheets before pulling them in to the Dashboard.
2. Use the same date ranges for every sheet throughout Pulse.