Help

Use spreadsheet-style formula functions in Zaps

Last updated:
Spreadsheet Style Formulas

Spreadsheet Style Formulas

You can use spreadsheet-style formulas in Zaps with the same syntax used in popular spreadsheet applications like Excel, Numbers, and Google Sheets.

This option can be used with numbers or with text.


1. Add a Formatter step

  • In the Zap editor, click the Action step, or click the plus + icon to add an action to your Zap.
  • Select Format.
  • Click the Action Event dropdown menu and select Numbers or Text, depending on the information you'd like to use.
  • Click Continue.
  • In the Set up action section, click the Transform dropdown menu and select Spreadsheet-Style Formula.

2. Set your formula

The Spreadsheet-Style Formula transform supports many different functions. You can use data from previous steps in your formula.

  • In the Values section, click the Formula field and enter your formula.
  • Click Continue..
Note

If the data you'd like to use in the formula includes letters (not just numbers), you must wrap the text in double quotation marks or the Formatter will error.
Comparing two text values by wrapping each in double quotation marks


3. Test your formula

  • Click Test & Review. You’ll see the results of your formula.
Note

If you’re using spreadsheet-style formulas to compare values, the output will be “true” or “false”. If the compared values are equal, the output is “true”. If the compared values are not equal, the output is “false”.

After setting up a spreadsheet-style formula, you can use the results of your formula in further actions in your Zap.


Need More Help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community