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.

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? 

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!

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? 
 

 

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")

 

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