Formula columns with AI

Looking to automatically calculate data in your pipeline?

Caitlyn Grundy avatar
Written by Caitlyn Grundy
Updated over a week ago

Formula columns are a great way to add more value to your pipelines. They allow you to create custom javascript formulas, without coding, based on other column data that you’re already tracking.

Powered by AI, you can type a prompt in natural language and the Streak formula editor will automatically generate the code and test it.

For example, you could write a formula to calculate the sales commission for each box:

  1. In the gray bar, you can type “deal size multiplied by 2%”

  2. Press enter on your keyboard and watch for the code to generate in the formula editor

  3. If no errors are returned, click “Save Code”, or ⌘/Ctrl + Enter on your keyboard

This article shares examples of frequently used JavaScript formulas.

Need a custom formula?

Feel free to reach out to us at or start a chat using the Streak help button at the bottom right corner of this page and we'll be happy to help.

Did this answer your question?