Category Archives: Technical

Before tonight’s turkey coma kicks in, I wanted to revisit the QUERY function from last post. We did a few neat things with survey response data and creating automatically-updating sub-sheets from a master. That’s all well and good, but I promised we’d go a level deeper. I promised IMPORTRANGE. We’ve already defined QUERY as: SoContinue reading “Back at it again with QUERY”

Three of my favorite things are eating QUERY functions and not using commas. In all seriousness, I am downright obsessed with this function. I realized that I might have a problem when yesterday was the second time in as many weeks that I had a 1:1 with a customer that was entirely around writing QUERYContinue reading “Google Sheets QUERY Function”