📖GPT Formula Reference

Each of these formulas are demonstrated in our public template. Arcwise - Public Template

Model usage

All Arcwise AI functions use the OpenAI gpt-4o models through Microsoft Azure. We take data privacy and security seriously: both our privacy policy and Azure's privacy policies guarantee that your data will never be sold or used for model training purposes.

For a limited time only, usage of AI formulas is completely free. (This will likely change at some point in the future!)

AI.TRANSFORM

Transforms a target value based on a prompt.

Examples

AI.TRANSFORM("Moby Dick", "write a short summary")
AI.TRANSFORM(A1, "write a short summary")
AI.TRANSFORM(A1, A2)

Syntax

AI.TRANSFORM(VALUE_TO_BE_TRANSFORMED, PROMPT)

AI.CLASSIFY

Classifies a value based on a list of categories. The list of categories can come from a range of cells.

Examples

AI.CLASSIFY("Moby Dick", "novel, article, snoozefest")
AI.CLASSIFY("Moby Dick", $A$1:$A$3)
AI.CLASSIFY(B1, $A$1:$A$3)

Syntax

AI.CLASSIFY(VALUE_TO_BE_CLASSIFIED, categories, [descriptions])

categories can be a comma separated list of values or a range of cells.

Optionally, you can also provide a range of descriptions to provide more information about each category. For example, if you had a table of customer support tickets, you could define a table of ticket categories and descriptions in a categories sheet:

	A	B
1	Return request	If the customer is trying to return an item
2	Billing issue	If there's an issue with the payment method
3	Quality issue	If there's an issue with the delivered product

This formula would then categorize A1 based on both the categories and the descriptions:

AI.CLASSIFY(A1, categories!$A$1:$A$3, categories!$B$1:$B$3)

AI.EXTRACT

Extracts a fact or data point from the input. For example, part of an address, or a person's name from an email, etc.

Examples

AI.EXTRACT("123 Main St. Jersey City, NJ 07302", "state")
AI.EXTRACT(A1, "state")
AI.EXTRACT(A1, B1)

Syntax

AI.EXTRACT(VALUE_TO_EXTRACT_FROM, ITEM_TO_BE_EXTRACTED)