November 2019 – Annie Sauer

Back at it again with QUERY

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”

Google Sheets QUERY Function

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”

NaNoWriMo 2019

It’s barely November and I’m already behind! I did this amazing NaNo Prep workshop back in September/October thinking that I was 100% ready to write. I was wrong. Sitting down in a coffee shop this past Friday, I found myself fiddling with the keys, typing a sentence and deleting it, and staring off into space.Continue reading “NaNoWriMo 2019”