> For the complete documentation index, see [llms.txt](https://docs.arcwise.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.arcwise.app/using-arcwise-in-sheets/formulas.md).

# Using Formulas in Sheets

### Writing Arcwise formulas

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:

<figure><img src="/files/4VjEc091jdRPbmtNPcE4" alt="" width="335"><figcaption></figcaption></figure>

Arcwise formulas run in your database; you should see a brief "Loading" message while the formula executes and the final value appears.

{% hint style="info" %}
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.
{% endhint %}

{% content-ref url="/pages/tM83Hk1ckIMZrqU1kxrt" %}
[Supported Formulas](/using-arcwise-in-sheets/supported-formulas.md)
{% endcontent-ref %}

### "Refreshing" Arcwise formulas

Unlike regular spreadsheet formulas, formulas that reference Arcwise data will not automatically re-calculate if their inputs change.

<figure><img src="/files/vCym9R2siZ6nrUwjQWIt" alt=""><figcaption></figcaption></figure>

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"!)

{% hint style="info" %}
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.
{% endhint %}

You can also refresh cells using the Chrome extension. First click on the formula button in the top right corner.

<figure><img src="/files/rqr5DQQLLyZlB7uUPP84" alt="" width="375"><figcaption></figcaption></figure>

Then select the appropriate button to refresh the formulas you are interested in.

<figure><img src="/files/xJQXH4ZQpbeCt3ZlKTn5" alt="" width="375"><figcaption></figcaption></figure>