🧪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.
Arcwise connected data tabs will only display a preview of 100 rows if the data is very large. Formulas on Arcwise connected data tabs will run on the entire data set regardless of whether just a preview shows in the sheet.
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 may also see #N/A values when copy/pasting or autofilling Arcwise formulas to other cells. Refreshing the cells will populate these cells with real values.
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.
