Formulas are the bedrock of any useful Google Sheet. Below is a list of all our articles that cover the subject of formulas. From how to use multiple formulas in a single cell to manually refreshing their output.
There’s more to formulas that just knowing function names!
There are 2 types of links in Google Sheets. Auto-generated links that sheets creates itself when you type in URLs, and links created using the HYPERLINK function. How you remove them differs slightly depending on how many links there are, and what type they are. There are pretty quick shortcuts to get rid of each … Read more
If you need to display the results of two calculations in a single cell, the simplest way is by concatenating the results of 2 formulas together as text either using an ampersand (&) or the CONCATENATE function. If your formula results are numbers or dates that need formatting, you will have to do this using … Read more
The simplest way to convert a range of cells from formulas to values is by copying them and using paste special to paste the values only. You can do this using the menus, or with keyboard shortcuts. I often need to convert formulas to values in a sheet when I’ve used a formula to fix … Read more
The quickest way to show all the formulas on a Google Sheet is to use the shortcut Ctrl+’ (⌘+’ on Mac). This will make every cell in your sheet display its formula instead of the result. Hit the same keyboard shortcut again to toggle the view back to the standard display. To view the formula … Read more
If you don’t want viewers of your sheet seeing how you generate your data, you’ll need to hide your formulas. There are 2 ways to do just that. Which you choose will depend on how technical your users are and exactly what you want to accomplish. Hiding the formula bar is very simple (View > … Read more
If you need variables in your google sheet, you have 3 options. The best option is to create a named range in your sheet that refers to a cell containing your variable. If you don’t want to store the variable in the sheet, you can use a named function or an Apps Script function. Which … Read more
Google sheets will automatically refresh formulas whenever you change the value of any cell in a sheet. If your data is based on the value of a volatile function like NOW(), TODAY(), RAND() or RANDBETWEEN() you can automate a recalculation of sheets formulas every minute or every hour by using sheet settings. To refresh your … Read more
In order to use line breaks, new lines or soft returns within a formula you need to enter them in as part of the formula definition. Google Sheets has a CHAR function that returns any Unicode character from its code or number. The decimal Unicode for a new line (line feed) is 10. So using … Read more