Skip to main content

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! 🙂

Reply


Terms & Conditions