✔️GPT Formula Basics

Be sure you have properly set up Arcwise: GPT Formulas Overview

We highly recommend copying our public template and following the instructions there! Arcwise - Public Template

Writing a GPT formula

To start writing a GPT formula use the $ symbols directly after the = sign when starting a formula. You will see a drop down of available options.

To complete the formula you can click a relevant cell that will be used as input or type an input.

All our AI functions take a cell/value as the first argument, and a description of what to do in the second argument.

Applying a GPT formula to many rows or columns

You can apply a GPT formula to many values in exactly the same way as a normal Google Sheets formula. There are two methods:

Dragging formulas

You can drag a formula from one cell across rows of columns:

When you do this you may see a block of #N/A values. This is indicating the the formula has not yet been computed. To compute the formulas click the refresh icon (next to the Arcwise icon) on the selected cells. The formulas will not compute until you click the refresh icon.

If you use the Ctrl+D (drag down) or Ctrl+R (drag right) keyboard shortcuts (⌘+D / ⌘+R on Macs), a refresh will be triggered automatically.

Pasting formulas

You can copy the formula and paste it into the other cells:

When you do this you will see a block of #N/A values and a shimmer. This indicates that the AI formulas are computing. When they are done computing you will see the resulting values.