# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.arcwise.app/using-arcwise-in-sheets/formulas.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.