How to refresh query based on a specific cell value
I've been having some trouble with a google spreadsheet that relies heavily on queries. The main query I use in this spreadsheet returns about 27 thousand rows and sometimes the results are incomplete. I wonder if there is a way to set a trigger to refresh that query based on a specific cell being filled or not, as it takes so long to refresh it manually during work hours it's impractical.
Thanks in advance