Bootstrapping Tools

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…

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…

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…

Got some columns that you would rather be rows? Or maybe the other way around? If you've been copy & pasting each one to get it in the way…

Have some "work in progress" columns you want to hide or need to bring two columns closer together temporarily? The Hide feature in Google…

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…

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…

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…

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…

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…

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…