Google Sheets App

1/1/15

More and more these days I’m thinking of powerful ways to use Google Sheets for business needs. I recently created an “App” of sorts using only Google Sheets.

The project requirements were to maintain a future schedule for the main meeting in my church. I’m responsible for planning this meeting, which includes finding people to say prayers, people to speak, and hymns to sing.

The problem I had to solve was to allow the people responsible for different parts of the planning to communicate with each other (real time) while reducing the possibility of someone overriding another’s data and keeping some sensitive information private.

The solution was three Google Sheets that talk to each other. I have a sheet for themes and music that is populated by the music people. I have the planning document (with sometimes sensitive/private data) that I use to record future speakers and prayers; this document pulls in the themes and music (real time). And last, I have a program document that dynamically shows the next three weeks of the schedule so programs can be made.

It works like a charm. I’ve only found one issue; if someone opens the main document on a mobile phone and they close it before the sheet calculates, it breaks the formulas and shows errors in the program document. The work around is to replace the formulas with values if a week is totally planned.

About The Author

Ben currently works as a senior developer and technical business consultant outside of Boulder, Colorado.

Read more about Ben

About Buink

Buink Web Development is a website development company founded in 2009. Although we still focus on web development, we now offer digital marketing services, web design, local SEO services, ecommerce website design, and custom logo design

Our value proposition: Buink can help you unleash the power of the internet and help your business scale with superior quality code at a competitive price and in a transparent, honest way. 

Read more about Buink

Buink Web Development
Excellent
5.0
Based on 5 reviews
Dave G.
Dave G.
Buink is a great place to work, as well as a great place to have quality software written. I originally contracted Buink for some web development, and it worked out so well we began working together on many different projects. Definitely an honest transparent company that needs to be considered for your software needs.
Response from the owner: Thanks for the kind words Dave!
js_loader

Connect with Buink

Connect with Buink via email, send us a message, or subscribe to our blog.