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