Can I reference cells from a spreadsheet in the document?

Yes! This is one of our most magical features. While you are in a document, type “=A1” and it will reference the contents of that cell in the closest spreadsheet. If there are multiple spreadsheets in the document you may need to use a full cell reference like “=SheetName!A1” in order to reference the spreadsheet you want. Please note: you will only be able to reference tables that are embedded in the same document where you are entering the reference.

You can also add formulas that calculate outside of the spreadsheet, such as “=MAX(A1:A5)

Was this article helpful?
4 out of 5 found this helpful