Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello all. The thing I want to do is that I want to SUM up all the numbers in this specific column “Monthly Profit” on a Zapier table.

 

 

I can’t just put them all as line items as this Zap will run everytime a new form (new month) gets submitted. So I can’t just do =SUM(row1, row2, row3) because a 4 will get added next month. I’ve also tried spreadsheet style of =SUM(“Monthly Profit”) ala Excel but it doesn’t work.

Can anybody help me in figuring this out? Thank you. 

Hi @creativelife 

Try these Zap steps:

  1. Trigger: APP] - EVENT]
    1. UP TO YOU
  2. Action: Zapier Tables - Find Records
    1. Need to add a column with a common value for all the records to use as the lookup
  3. Action: Formatter > Numbers > Perform Math Operation
    1. Type: Add
      1. Used to SUM the values
  4. Action: APP] - EVENT]
    1. UP TO YOU

Hey @creativelife 👋

How did you get on with Troy’s suggestion here? Did that approach help to get the sum of all the values in that Monthly Profit column?

Let us know if you’re still stuck on this at all, keen to ensure you’re all set! 🙂

Just circling back in here to share that we’ve added Summary formulas to Zapier Tables which can be used to calculate the total sum of a table column! 🎉

Check out the Add a summary formula to a field in Zapier Tables guide to learn more.

Also, we’ve recently added Formula fields which you can learn more about here:

Happy Zapping! 😁⚡️

Terms & Conditions