Month: March 2019

Easy garden hoops

We came up with this simple way of making a small hoop house for lettuce a couple of years ago. It uses lengths of 3/4 inch PVC and 1 inch PVC to make the hoops. I’ll buy snap clips from Johnny’s to attach some shade cloth as it gets warmer.

Sacrament Meeting Master Planner

This is the Google Sheet my ward uses to coordinate sacrament meeting. This is the third version of this document I’ve worked on, and this one is the best. Here’s what it does: Lists speakers by first name, alphabetically, with the date of their talks. This makes it easy for you to find out when

How to INDEX multiple columns

I needed to check multiple columns in different spreadsheets and output the matching result. I wasn’t sure that VLOOKUP would work for this case and INDEX-MATCH is supposed to be better anyway, so I used the following code. It uses IFERROR to nest MATCH functions: The above checks for matches in colums A, Q, and

How to SORT multiple columns in Google Sheets

Yesterday I was working on a spreadsheet that needed to SORT items from several different columns. SORT only accepts one argument, and I couldn’t find any examples online about how (or if) you could SORT multiple columns. Maybe this is obvious to everyone else, but it wasn’t to me. The answer is to put arguments

Flashback

My best friend and roommate from BYU was called last Sunday to be the Young Women’s president in her ward. Her ward and stake split at the same time, and her ward lost a lot of leadership and not many youth. The ward had about 80 active youth. Many of the boys went to a