About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

Formulas aren't registrating data from the Zap

  • 17 January 2023
  • 4 replies
  • 115 views
A
Badge

Hi Zapier Community, 

I am currently running the following zap, on Monday.Com and Google sheets: 

1: Specific Column Value Changed in Board in Monday.com

→

2: Create Spreadsheet Row in Google Sheets

 

I am getting the correct data into my sheet. But the problem is that my formula isn’t registrating the data in the columns from the Zap. 


I am running simple formulas such as: countif, countifs, sum etc. So it shouldn’t be a problem.

Any clue how to solve this issue? 

icon

Best answer by AB98 17 January 2023, 13:35

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Danvers
Userlevel 7
Badge +12

Hi @AB98!

Where are the formula in you sheet? Are they in the same row as the data that’s added by the Zap or in a different sheet?

If they’re in the same row as the data, you might find this guide to adding indirect formulas in your Zap useful:

If that doesn’t help with what you need, could you share some more details about the formula: where are they in the sheet, what are they (the exact formula) and which cells do they reference. Thanks!

A
Badge

So basically my sheet rows that recieves the zap are A,B and C

My formulas are from F to V

Does this make sense? 
 

 

A
Badge

I figured it out with using Countifs combined with the INDIRECT function. 

If anyone else needs this formula this is the one I use: 

 

=COUNTIFS(INDIRECT("A2:A1000"); "row item you are looking for 1"; INDIRECT("B2:B1000");"row item you are looking for 2")

 

jesse
Userlevel 7
Badge +9

Hey @AB98 glad you were able to get this sorted and thanks so much for coming back to the Community to share! I will go ahead and mark your reply as a “Best Answer". If anything else comes up, just let us know - always happy to help brainstorm ideas & solutions!

Terms & Conditions