Tag: google sheets

Posts tagged google sheets

Partial Data Regression Line in Google Sheets

Excuse the crummy title. I ran into an interesting graphing problem in Google Sheets that I'm documenting here for anyone else who might have the s... Read more

Sort a Google Sheet with Vertically Merged Ranges

This is a quick tip, but if you've ever tried to sort a sheet with vertically-merged rows, you've probably been disappointed. Here's an example: If... Read more

Change Document Ownership with Apps Script

My Google account is managing a lot of document creation at school. I set up a lot of autoCrat projects to create docs alongside several utility sc... Read more

Dynamic Data Validation with Apps Script

My coworker, Kat, needed to set up meetings with our 13 elementary schools. Appointment slots would have been a lot of clicking back and forth on c... Read more

Getting the Axes Right in Google Sheets

I think I finally figured it out. Getting charts and graphs created in Google Sheets (or Excel for that matter) has always been somewhat of a wrest... Read more

Get in touch

Comments are always open. You can get in touch by sending me an email at brian@ohheybrian.com