How to Insert Checkboxes into Google Sheets
Sure you could just enter in "true" and "false" or "yes" and "no" into your cells, but that's not as easy to scan through like a checkbox is…
How to Insert Checkboxes into Google Sheets
Sure you could just enter in "true" and "false" or "yes" and "no" into your cells, but that's not as easy to scan through like a checkbox is…
How to Get the Min or Max Value from a Dataset
Sometimes you have a huge dataset and you just want to know what the min/max values for certain range. In Excel or Google Sheets, you can…
How to Calculate the Number Days Between Two Dates in Google Sheets
If you're trying to calculate the amount of time between two dates, there's an easy way to do that in Google Sheets via the =DATEDIF…
How to Combine Text Together in Google Sheets
Have a few text fields in your spreadsheet that you want to combine? Things like "First Name" and "Last Name", or maybe an address with its…
How to set multiple alternating table row colors in Google Sheets
Be sure to read How to Set Alternating Table Row Colors Google Sheets for the basics first!
In this How-to, we'll go over setting different…
How to use Named Ranges in Google Sheets
If you're working with lots of data, you're probably updating it regualrly. Named Ranges can help make sure that you "referenced cells" don…
How to track time in Google Sheets
Trying to figure out how long it took to complete a task? Use =DATEDIF(start_date, end_date, time_unit) calculate the amount of days, months…
How to get the month from a date in google sheets
Have a bunch of rows that you want to group by month, but you only have the individual dates? Use =MONTH(date) to convert those dates into…
How to get the number of unique values in a dataset
Need a way to figure out how many unique values you have in a dataset? Use =COUNTUNIQUE(A:A) to get the count of unique values. Easy…