Google Sheets and =ARRAYFORMULA ( )

My supervisor and director of our office, Amy Garbrick, likes spreadsheets. Who doesn’t, when they are well formatted? They are a great way of processing lots of data quickly.

I use a number of project management tools and Google Sheets is one of them. I have one particular sheet that is very extensive that I’ve been using for some years now to track all of the tasks I need to do in order to prepare new sections for upcoming semesters. The devil is in the details and I’ve been burnt by the devil many times in the past.

While the sheet does a good job for me, I’ve been looking for a way to quickly and easily distill parts of my spreadsheet for others. There’s too much data for quick reviews that Amy and others need. I found a discussion post that led me to a great solution. This information wasn’t enough, but I found a YouTube video that helped me to piece it all together.

It involves using the =ARRAYFORMULA( ) formula to pull data from cells in a different worksheet and allows me to format that data in such a way that others can make sense of it.