Sheetgo Blog

Your go-to resource for all things spreadsheet related

How to use the ROWS formula in Google Sheets

Assume that we have a range of cells in a spreadsheet that we are interested in. And we want to know how many rows it has spread across. We could probably do a quick count manually if there are only a few of them. But more often than not, we encounter instances where...

read more

How to use the MMULT formula in Google Sheets

Spreadsheets have come a long way since they were first available, thereby making our lives a lot easier. Today they provide us with a myriad of tools and formulas, which will help us with most of our mathematical and statistical calculations. Therefore, it is no...

read more

Top 5 Google Sheets Add-ons for Sales

If you're in sales, you know that it takes a lot of hard work to stay organized and ahead of the game. You probably spend a lot of time on Google Sheets creating reports or organizing manually collated data. Consider trying add-ons to work smarter and get some of your...

read more

How to use the LEFT formula in Google Sheets

The spreadsheets applications of today are extremely versatile and useful tools. While they are known primarily for handling numbers, they also provide multiple utilities that help us operate on text values. In this post, we will be learning about the LEFT formula in...

read more

Import Formatting With IMPORTRANGE In Google Sheets

Smart data organization is critical to the success of a company or project. Data needs to be well formatted so that people can actually understand and use it. Raw data might be great to feed into machines, but humans need data that is efficiently structured and...

read more

How to use the LEN formula in Google Sheets

Using spreadsheets we not only can deal with numbers but also with text. We have a multitude of text formulas at our disposal that can help us manipulate the strings. The LEN formula in Google Sheets is one of them that we use very commonly. It simply returns the...

read more

How to use the LOWER formula in Google Sheets

We know we use the spreadsheets applications generally to working with numbers. But we also have a good help in terms of a number of text-based formulas at our disposal. By making use of these, we can manipulate the strings in many ways according to our needs. The...

read more

Top 5 Google Sheets Add-ons for Education

Google Sheets is an awesome tool for creating projects or tracking information. But, sometimes, you need these tools to do a little more for you. As a result, third-party developers create advanced “add-ons” that can supercharge the capabilities of your Sheets....

read more

How to use the LN formula in Google Sheets

Spreadsheets of today are comprehensive tools that help us with everyday calculations. Be it elementary or advanced, they got a bundle of mathematical functions to offer. The LN formula in Google Sheets helps us to calculate the natural logarithm of a value. It...

read more

How to use the RAND formula in Google Sheets

In fields including but not limited statistics, science, gaming, cryptography etc. the use or random numbers is a commonplace. For instance, statisticians may use randomness in a randomized experiment to test their hypotheses. Because, a random number usually follows...

read more