1. Named Ranges
We’re happy to share that support for named ranges has been released in today’s update. With named ranges, you can assign a name to a contiguous range of cells for easy reference in formulas.
To use a named range in a formula, input the name of the named range (without quotation marks) where a cell or range would otherwise be used in the formula. As you write your formula, Spreadsheet.com will autosuggest named ranges, indicated by the teal NR symbol next to the named range, as shown below.
For example, let’s say that you’ve created a named range called “Q4_Earnings” including cells E6 through E10 and you want to generate a sum of these values in another cell. Normally, your function would be written as:
With your named range, you can instead write the formula as:
You can reference the same named range in any subsequent formulas you define as well, giving you a quick point of reference that doesn’t require you to remember or re-reference the original range.
Zapier integration is now fully available and in public beta. We’ve highlighted 16 of the most popular apps we’ve heard from users about in the updated Integrations page on our website, including Google Sheets, Salesforce, Jira, and Quickbooks.
For more details and step by step instructions, see the new Zapier Integration section of our help center.