AI Formula Assistant

The hardest part of working with spreadsheets made easy with AI.

Faster formulas

Working with dates

No one likes dates. Not even computers like dates.

Still, Grist’s Formula Assistant has the ability to work with dates in any way you see fit.

Working with strings

Say goodbye to CONCAT() chains. Say goodbye to endless IF(SUBSTITUTE()) nestings.

Just say what you want to do to a bunch of strings and watch the power of generated Python do its thing.

Working with patterns

Need to validate data? Extract particular elements? Stuck on regular expressions?

Describe the pattern you’re looking for the Formula Assistant will help make your match.

Sign up now

Receive 100 AI credits when you sign up for free.

Grist’s unique approach

Screenshots showing creating a column, asking the assistant for help, and applying the formula.

Do one thing well

Grist’s custom-tuned prompts allow you to create formulas using plain language – simple as that.

Just describe the desired output, and Grist’s Formula Assistant will help get you there.

Flow chart showing a user altering their messages to the assistant as they develop a formula.
AI Iteration

Work together

Nobody’s perfect, and neither are AIs.

Use the retained conversational context to adjust and improve your formula, right in Grist.

Grist screenshot
Beyond the Grid

Spreadsheets + databases

Grist’s unique structure and full Python integration makes advanced AI-generated formulas possible.

You write the message, Grist passes along your document’s structure as context, and the AI pulls on its vast corpus of Python code.

Try it now!

Sign up for free and use Grist’s AI Formula Assistant – available now.

Frequently Asked Questions

How can I access Grist’s Formula Assistant?

All you need to get started is a Grist account. Free accounts receive 100 AI assistant credits. Each chat message costs 1 credit. Simply create a formula column, open the AI assistant, and describe what you need.

Learn how to use the assistant on our AI Assistant Support page.

How much does the AI Assistant cost?

Free personal and free team plans have 100 AI Assistant credits (or requests). For free team sites, that applies to the whole team.

Pro plans include 100 AI Assistant credits per month. The credits automatically top up to 100 every billing cycle. Credits apply to the whole team. It costs one credit per chat message sent. If you need more credits, there are two upgrade options:

  • 500 monthly credits for $10 per month (per team, not per person)
  • 2,000 monthly credits for $29 per month (per team, not per person)

Upgrades are renewed automatically each month. Unused credits do not roll over to the next period.

Read more information on our AI Assistant Support page.

Which Model Does the Assistant Use?

Grist’s AI Formula Assistant uses the gpt-3.5-turbo model (aka ChatGPT).

Grist self-hosters can also use gpt-4 as a chat completion endpoint, as well as the LLaMA family of self-hostable models via llama-cpp-python.


No user data is sent until a user submits a message to the assistant.

Upon submission, your query and schema are sent to OpenAI so that the assistant may better understand your document. You can view your data’s schema in code view.

For more information, read our AI Assistant Data Use Policy.


For self-hosters looking to connect their Grist instance, set the AI Formula Assistant-related variables to configure ChatGPT or local endpoints as available.

Learn more about self-managing Grist.

How is Grist’s Formula Assistant different from other AI tools?

Grist focuses on a “Formula Assistant” instead of a more generalized generative AI tool for two main reasons:

  1. Grist is different than other spreadsheets. With Grist, the structure and relationship of the data is explicit (and can be seen in Code View). This gives the AI tool an extra understanding of how the data in your document is connected. You can see an example of this in our original AI experiment.
  2. Grist formulas use Python, and LLMs like ChatGPT “know” a lot of Python thanks to the language’s popularity and longevity.

Organize your data, your way

Unlock a better way to work with your data.