βœ”οΈGPT Formula Basics

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:

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.

Last updated