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.

I have an operation where I’d like to do some math with formatter before placing the data in a spreadsheet. The only problem is the number of output items from the previous formatter step can vary quite a bit. I can easily use outputs 1-5 in the screenshot below, but when another trigger comes through that produces more than 5 output items it would only add up to 5. Is there anyway to to have it add all output items or possibly another way to accomplish what I’m trying to do?

 

Thanks! I’m usually good at finding answers myself but this simple issue has me stumped.

 

Hey ​@Asterisk,

Try using Formatter → Numbers → Spreadsheet-Style Formula action to do the SUM().

 


Map the output text from the previous formatter inside (). Hope it helps!

Thank you, it still produces individual output items though as opposed to a sum unfortunately. I was able to solve it with javascript

 

// Get the input string (or empty fallback)

const raw = inputData.numbers || "";

 

// Split into numbers, clean, and filter out non-numeric values

const nums = raw

.split(',')

.map(n => parseFloat(n.trim()))

.filter(n => !isNaN(n));

 

// If no valid numbers found, return 0 safely

const sum = nums.length > 0 ? nums.reduce((a, b) => a + b, 0) : 0;

 

return { sum };

Hey ​@Asterisk,

It will produce a sum only if you will pass the correct input in it. Nice you were able to solve it with Javascript but advantage of Formatter over Code is it doesn’t use any tasks in Zapier. Hope it helps!

Oh good to know, I’ll give it another shot. Thanks ​@Sparsh from Automation Jinn !

Terms & ConditionsAccessibility statement