Named ranges make your formulas easier to read and maintain by assigning a custom name to a range of cells.

Instead of writing:
​=SUM('Report Data'!C11:Z11)
You can use a named range to make it more intuitive:
​=SUM(MonthlySubtotals)

You can see all your named ranges in the Name Box, located in the top-left corner next to the formula bar.

For instructions on how to create your own named ranges, check out Google’s guide.

LiveFlow automatically creates and updates six named ranges for every report. These ranges adjust dynamically whenever you refresh your report—so you never have to update them manually.

✅ Always Up-to-Date – Even if you add or remove rows and columns, your formulas will continue to work.
✅ Consistent Naming – Named ranges follow a predictable format, making it easy to reference reports.
✅ Automatic Updates – If you rename a sheet, LiveFlow updates the named ranges and any references to them.

Each named range follows this format:
​_{SheetName}RangeName (e.g., ProfitLoss_Report)

➡ Covers the entire report area.
✔ Useful for lookup functions like VLOOKUP, QUERY, and DSUM.

➡ Contains data about the report (e.g., company name, currency, period).
✔ Useful for lookup functions like VLOOKUP when referencing report details.

➡ Points to a single cell showing the report’s last refresh date/time.

➡ Covers the row labels (first column, starting below column headers).
✔ Works well with VLOOKUP and INDEX/MATCH.

➡ Covers the column labels (first row of the report, starting from the first data column, typically column C).
✔ Often combined with {SheetName}_RowLabels and {SheetName}_Contents in lookup formulas.

➡ Covers the actual report data, bounded by {SheetName}_RowLabels and {SheetName}_ColumnLabels.
✔ Ideal for XLOOKUP or INDEX/MATCH formulas.