Can I reference cells from a spreadsheet in the document?

Yes! Inline formulas are one of our most magical features. While you are in a document, type = then either click on the specific cell you want to reference or type in the cell ID (e.g. =A1) and it will reference the contents of that cell in the text section. Typing in @formula does the same thing.

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. You can also add formulas that calculate outside of the spreadsheet, such as =MAX(A1:A5)

Please note: you will only be able to reference tables that are embedded in the same document where you are entering the reference.

Screen_Shot_2020-08-05_at_5.52.00_PM.png

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