I’m trying to have ActiveCampaign update Deals or create new rows for new Deals into a Google Sheet. Everything is working great except for some reason, ActiveCampaign spits out dollar amounts in CENTS and not whole dollars which is just...frustrating. I have multiple columns in my Google Sheets that need to be dollar values formatted as currency. I can get my zap to divide by 100 to get the proper dollar value and format it correctly, the thing I’m having trouble with is how to format 3 different columns this way without having to do a math step and a formatting step each time. Is this possible?
Here is some sample data with the two columns highlighted that are coming over as cents instead of dollars. What’s the most efficient way to achieve conversion to whole dollars?
Question
How to format multiple value fields and perform math? (ActiveCampaign-->Google Sheets)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31004 replies
Hi
A Code step could be used to handle the math conversion: https://zapier.com/apps/code/help
Example: https://zapier.com/help/create/code-webhooks/javascript-code-examples-in-zaps#step-4
I appreciate your response, though! +14- Zapier Expert
- 31004 replies
Your options are multiple Formatter steps or 1 Code step.
Or you can try using this Formatter step: Formatter > Numbers > Spreadsheet-Style Formula https://zapier.com/help/create/format/understand-spreadsheet-style-formula-functions
You can also code formulas into the GSheet step like such: =[VALUE]/2
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.