Don't run query when cell is empty


I'm currently automating our project evaluation systems, and as such I'm working on a Google Sheets template that runs queries based on data that's entered in particular cells. However, since each project is different, the amount of queries needed varies as well. Is it possible to stop a query from running if a particular cell is empty? I've included a strippd down example of what I'm aiming for. 


  • For completeness' sake (forgot this in the last message): since we're using some crossreferences in our queries we're working through the 'SupermetricsQueries' tab rather than the sidebar: if some parameters need to be altered in order to refrain them from running that's perfectly fine for us, too.

Login to post a comment