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.

Best answer

Adding formulars to excel sheet

M

Hope you could probably help me.

 

Actualle I am using Google Spreadsheets for my reporting which works really fine as I also can use the “Update row” action to add formulas to my report by simply adding “=formula()” - for example I calculate the calender week this way. Google Spreadsheets accepts this and calculates it right away.

 

Now I am thinking of switching to Excel using the same action but in the Excel sheet I always get the “#name?” error even when everything is right. I got this error after Zapier has updated the data. I I know click into this specific cell and hit enter, the error is gone and everything is calculated. But that's not how I need it as this is no automated calculation.

 

Do you have any clue / hint how to solve this problem and be able to enter formulas via Zapier directly into my excel sheet?

Best answer by KelseyBratcherBest answer by KelseyBratcher

Have you tried using Array Formulas? Im not sure in Excel, but in Sheets they work.

Array formulas run a formula on an entire column. 

You need to be careful with the criteria by using if/then to determine if the array formula should apply.

So for example on a blank row, you probably don’t need to run the formula.

=ArrayFormula(IF(ISBLANK($A$2:$A),"",SUM($B$2:$B))) is an example of what I mean.

So if the A2:A is blank, the output of the array formula for that row is blank.

You can run these in excel, but its done a bit differently.

 

View original
ChrisP
ikbelkirasan
2 people like this
  • ChrisP
    ChrisP
  • ikbelkirasan
    ikbelkirasan
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Liz_Roberts
Forum|alt.badge.img+8
  • Liz_RobertsZapier Staff
  • Zapier Staff
  • 1366 replies
  • May 27, 2020

Hi @Marcel ,

Thanks for reaching out!

I am escalating this to Support as they will be able to take a look at your specific Zap configuration to help troubleshoot and provide guidance. 

Someone will be in touch via email just as soon as they can!

nicksimard
Forum|alt.badge.img+11
  • nicksimardZapier Staff
  • Zapier Staff
  • 2115 replies
  • August 18, 2020

Hi @Marcel!

I'm checking in with you here, since I don’t see a response to the message that our Support team had sent you. Have you managed to resolve things or did you still need help here? Please let us know :)

KelseyBratcher
  • KelseyBratcherZapier Expert
  • Zapier Expert
  • 5 replies
  • Answer
  • August 18, 2020

Have you tried using Array Formulas? Im not sure in Excel, but in Sheets they work.

Array formulas run a formula on an entire column. 

You need to be careful with the criteria by using if/then to determine if the array formula should apply.

So for example on a blank row, you probably don’t need to run the formula.

=ArrayFormula(IF(ISBLANK($A$2:$A),"",SUM($B$2:$B))) is an example of what I mean.

So if the A2:A is blank, the output of the array formula for that row is blank.

You can run these in excel, but its done a bit differently.

 

15,000,000+ minutes saved and counting! https://zapier.com/productivity-calculator/
Terms & Conditions