> 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="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FLIwPbhPDaJyhnUS10ijW%2FCleanShot%202023-07-09%20at%2013.08.14%402x.png?alt=media&amp;token=98ef73de-f72c-4675-a8ce-7f80e15733f8" 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="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FEqS3eElvnz59OatoPWaO%2FCleanShot%202023-07-07%20at%2018.27.55%402x.png?alt=media&amp;token=539b1335-d153-4872-aef7-f56d62ae7485" 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="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FDujFMunH4N2TmzzLwyay%2FScreenshot%202024-04-02%20at%2010.35.18%20AM.png?alt=media&amp;token=ac7dcb43-d689-4518-be15-ec643d0d95e0" alt="" width="375"><figcaption></figcaption></figure>

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

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FPIryj0PNOKibbd0e3UcP%2FScreenshot%202024-04-02%20at%2010.35.33%20AM.png?alt=media&amp;token=bbe71450-5f73-4856-9d4a-65c0aa9c54dc" alt="" width="375"><figcaption></figcaption></figure>