Using Formulas

Spreadsheets supports all formulas available in Wdesk Workbooks, as well as having some Spreadsheet-specific formulas.

Entering Formulas

You can type formulas directly into an active cell or enter them into the Formula Bar. Additionally, tooltips will offer suggestions and explanations for formulas as you type in the Formula Bar.

You can also click the fx icon to see all available formulas. When highlighting a range of cells, you can see the values for AVERAGE, COUNT, and SUM in the bottom-right corner of Wdesk without needing to type these formulas out.

image alt text

To display all formulas in a Spreadsheet, go to the View tab and click Show Formulas. Click the button again to show values.

Cross Sheet Formulas

If you need to reference a cell in another sheet, you can do so by beginning your formula, then navigating to the desired sheet and clicking the cell you want to use. This automatically places a reference to that cell in your formula and links your formula to the source cell, meaning that this formula will update when the linked cell is edited.

Cell Properties

You can see the cells used in a formula as well as any references to a given cell by selecting the cell and opening the Cell Properties in the right-hand panel.

image alt text

By clicking Current Sheet, you can see which cells the current highlighted cell references in its formulas. You can click a specific reference to see the exact values being used and click the Go to Reference button to jump to that reference in your Spreadsheet.

If the selected cell is being referenced in another location, you can click Referenced By to view these references. You can click a specific reference to see how the selected cell is being used. You can also use the Go to Reference button to jump to a specific usage.