Supermetrics Support Forum

QUERY FUNCTION IN GOOGLE SHEETS -Facebook and Google Analytics Comparison

HI!
(QUESTION TO ADVANCED USERS)

Can anyone point any error in my formulas?

 

I want to transfer data from one sheet to a column in another - matching the date.

After entering the formula - the column returns empty fields, and where it should be given is #ref.

That's why I wanted iferror formula to fill the field with zero.

After adding the iferror function - it does not work at all.

=QUERY('Google Analytics'!$A$2:$H$639;"SELECT E WHERE A=date'"&TEXT(A2;"yyyy-mm-dd")&"' and B='"&B2&"' and C='"&C2&"' and D='"&D2&"'")

=IFERROR(=QUERY('Google Analytics'!$A$2:$H$639;"SELECT E WHERE A=date'"&TEXT(A2;"yyyy-mm-dd")&"' and B='"&B2&"' and C='"&C2&"' and D='"&D2&"'"), 0)

The formula comes from this video: 
https://youtu.be/5XxaXvVQWvc?t=1239

Login to post a comment