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?
Best answer by AB98Best answer by AB98
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")
+12Hi
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")
+9Hey
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
