Previously the Joined Report and Master (SQL) Report were a special type of report. To reference them, you had to remember to use the special name joinedReport1! or masterreport!.

Now they are just a subset of a standard report. This makes referencing them in SQL and on the Spreadsheets function easier.

Their names also change a little. Joined Reports will be be titled Report # (Joined). Master Reports will now be titled Report # (Master SQL)

But the most important change is how to reference these reports.

When referencing one of these reports in SQL or Spreadsheet functions, you'll use the report number only from now on. So if you want to reference Report 3 (Joined) in spreadsheet functions, you will simply write report3.

Current metrics will be migrated to this new syntax. So if you have current metrics that reference joinedReport2 or masterreport, they will automatically changed to this new reference syntax. No change or action is needed on your part. 

If you want to learn more about referencing reports, check out this article.

Referencing a spreadsheet function cell remains the same. To reference cells in spreadsheet functions use spreadsheet!

Old Syntax:

Old syntax used to reference a Joined Report was joinedReport1!
Old syntax to reference the master report was masterreport!

Example
=report1!A2
=joinedReport1!B3 + report1!B5

New Syntax:

To reference all reports including Join and Master reports use report1! or report2!, etc.

Example
=report1!A2
=report1!B3 + report3!B5

Questions? Email us at support@grow.com or chat in on the site.

Did this answer your question?