Working with 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 will automatically place a reference to that cell in your formula. At this time, linking into or across spreadsheets is not supported.

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.

Advanced Formula Editor

To easily understand complex formulas, you can click Expand on the right of the formula bar to enlarge the viewing area. You can then change the formula using the Advanced Formula Editor. Each part of the formula will appear on a new line, and formula components will be grouped by indentation.

TIP: This expanded view is useful when reviewing a formula for correctness, such as when you are taking a document over from another user.

image alt text

Each new argument (separated by a comma) or formula (separated by a parenthesis) will appear on a new line in the expanded formula editor. Cells referenced will appear in a unique color to help differentiate them. You can also click the arrow to the left of a line to expand a portion of a formula to see it in more depth.