Using Formulas in Sheets
Last updated
Last updated
Spreadsheet formulas that reference Arcwise tables will automatically execute on the full dataset in the database. If you reference a column from an Arcwise sheet tab, you should see an Arcwise icon appear in the formula bar:
Arcwise formulas run in your database; you should see a brief "Loading" message while the formula executes and the final value appears.
Unlike regular spreadsheet formulas, formulas that reference Arcwise data will not automatically re-calculate if their inputs change.
When a cell needs to be refreshed, it will change to a light blue background and its value will appear as #N/A
. You can refresh these formulas with the inline refresh button shown (keyboard shortcut: Cmd + E on MacOS or Alt + E on Windows. "E" is for "Execute"!)
You can also refresh cells using the Chrome extension. First click on the formula button in the top right corner.
Then select the appropriate button to refresh the formulas you are interested in.