Error in email when spreadsheet contains "query" or "filter" functions
I use Supermetrics to collect data from my Facebook pages in a Google Spreadsheet. I have to filter the data before sending it to my coworkers (using the scheduled emails from Supermetrics add-on), so I use another sheet that contains a "query" or "filter" Google function that takes all the data provided by Supermetrics in the first sheet to give the relevant statistics. However, the test emails give "#N/A" instead of the data that was filtered...
Choosing a single sheet or the whole file does not affect the result.