Connect To Sheets – Pulse Dashboard

Topic Progress:

How to get data from other sheets

To pull data from other spreadsheets, use the IMPORTRANGE function.

Click here for details.

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.

>