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