Best of 2018: Sheetgo’s top 10 blog posts

Best of 2018: Sheetgo's top 10 blog posts featured image

Written by Valentine Schelstraete

Jan 11, 2019

Let’s get ready for 2019…

We want to look back on an amazing Sheetgo year by presenting you with the best of 2018, top 10 blog posts that provided you with tips and tricks on how to use Google Sheets and all its possibilities, but also the extremely handy Sheetgo Templates that let you automate your manual spreadsheet work.

Make sure to check them out to be totally ready to tackle all spreadsheet challenges that will come your way in 2019.

By looking back on all the amazing things we’ve learned in 2018!

How can I filter Google Sheets without affecting other users?

Top 10 Blog Posts in Sheetgo: Magnifying Glass to Filters a Building

Our most-read article, explaining how to apply filters without hampering the experience of other users working on the same spreadsheet.

Man Pointing with Pen to a Color Template

How to change the cell colors based on the cell value in Google Sheets? This functionality is called conditional formatting. Explore with a couple of examples.

How to change the cell colors based on the cell value in Google Sheets?

Import Range: how do I use it? Instructions and tips

Learn more about one of Google Sheet’s most useful functions Import Range. Its applications, strong and weak points and most of all how to use it!

Luckily, Google Sheets has recently expanded its cell limit from 2 to 5 million cells per sheet. Read more about how to still avoid too heavy spreadsheets in this article.

How to solve the 5 million cells limit of Google Sheets?

Top 5 Free Google Sheets Inventory Templates

Find out which ready-made templates for inventory management we chose as the top 5 in 2018!

The LOOKUP formula in Google Sheets searches through a row or column for a key and returns the value of the cell in a result range located in the same position as that of the search row or column. 

How to use the LOOKUP formula in Google Sheets

How to use the IFS formula in Google Sheets

The IFS formula takes in a set of expression and value pairs, evaluates them in sequence, and returns the first value whose corresponding expression is TRUE.

Top 10 Blog Posts: Switch on the Wall

The SWITCH formula’s functionality is pretty much similar to that of the nested IF formula constructs. Except, the syntax is simpler. Learn more in this blog post.

How to use the SWITCH formula in Google Sheets

How to use the SORT formula in Google Sheets

Best of 2018 Sheetgos Top 10 Blog Posts: Sorted Colors of Green and Blue

The SORT formula in Google Sheets helps us sort and return the rows in a range either in ascending or descending order.

Top 10 Blog Posts: Two Hands Matching Puzzle Pieces

In Google Sheets, the MATCH formula gives us the relative position of an item in a range of cells.

How to use the MATCH formula in Google Sheets

This was 2018.

We are happy we could provide you with helpful posts and instructions last year! Which one is your favorite? What kind of post would you like to see more in 2019? Please do not hesitate to let us know in the comments section below. 🙂

You may also like…

Share This