Back to Capability Graph

Google Sheets

Google Sheets are incredible. And it's a shame to watch their power go to waste by inefficiently designed sheets and not using formulas that could save hours of work.

What I'm seeing out there

  • You have a lot of your data in Google Sheets. It's simple, but it could be more efficient.
  • Your team could use some help with laying out the data in the sheet.
  • Maybe you noticed there's a lack of use of formulas and some data is very manually, redundantly entered.
  • You notice that a lot of rows get highlighted to signal information.
  • The problem with those highlights is there's no way to report on that—there's no formula to "find highlighted rows".

How I can help

I want to help your team get the most from Google Sheets, starting with the fundamentals: columns and rows have meaning—here's how to use them.

Then, we'll talk about basic formulas to more advanced formulas, like QUERY() and REGEX() and things that look like this:

=if(and(B2<>"",COUNTA(SPLIT(E2," "))=1),concatenate(B2," ",I2),if(and(B2="",len(E2)>1),E2,if(and(B2="",len(E2)=1),concatenate(E2," ",I2),if(isblank(E2),I2,""))))

Yes, I wholeheartedly believe we can teach all your employees how to use a formula like this, in time.

Apps Script

Automation

Once we have nicely designed Sheets, then we can even start doing some really amazing things with Apps Script.

Apps Script is Google's tool for writing Scripts on Google Workspace apps, including Sheets. Apps Scripts can do some really fancy, serious time-saving automation.

Example scenario

Tired of that repeat, manual step of moving that row from Sheet1 to Sheet2 when it meets a certain criteria?

Apps Script handles that for you automatically with just about 5 lines of JavaScript.

What Apps Script can do

  • Automate repetitive data entry and movement
  • Pull data from external APIs directly into your sheets
  • Create custom functions for your specific business logic
  • Send automated emails based on sheet data
  • Build custom menus and interfaces for your team
  • Connect multiple Google Workspace tools together

Related Services

Google Sheets often feed into CRM systems or support nonprofit operations. And when your sheets get complex enough, you might want Knowledge Management to document how everything works.

Let's optimize your sheets

Ready to stop wasting time on manual work that formulas and automation could handle? Fill out the contact form and let's talk about what's possible.