How To Mimic Radio Buttons With Formulas and Checkboxes

In this post, we’ll look at how to mimic radio buttons with formulas and checkboxes in Google Sheets.

Radio button behavior with checkboxes and formulas

This formula method has one limitation: you have to uncheck the current selection before you can check a different one.

With true radio buttons, when you click any button it will unselect the other one for you. You don’t have to do the extra step of manually unselecting it first.

For that reason, I recommend using an Apps Script method to create true radio buttons in Google Sheets.

However, the formula method presented in this post is useful if you don’t have access to Apps Script or simply don’t want to add code to your project.

Continue reading How To Mimic Radio Buttons With Formulas and Checkboxes

How To Create A Select All Checkbox in Google Sheets

In this post, you’ll learn how to create a Select All checkbox in Google Sheets, as shown in this image:

select All Checkbox in Google Sheets

But before we look at that, did you know there’s already a quick way of selecting all checkboxes manually?

Continue reading How To Create A Select All Checkbox in Google Sheets

How To Use The RANDBETWEEN Function In Google Sheets

The RANDBETWEEN function in Google Sheets is used to generate a random integer (whole number) between two values.

For example, this RANDBETWEEN formula generates a random number between 1 and 10:

=RANDBETWEEN(1,10)

RANDBETWEEN Function In Google Sheets

The function will generate a new random number each time your Sheet changes.

Continue reading How To Use The RANDBETWEEN Function In Google Sheets

How To Create A Random Number Generator In Google Sheets

The RAND function in Google Sheets generates a random number between 0 and 1 and can be used as a random number generator in Google Sheets.

Random Number Generator In Google Sheets

The RAND function outputs a decimal number between 0 and 1, for example, 0.2760773217.

Continue reading How To Create A Random Number Generator In Google Sheets

Formula Challenge #6: Split A String Into Characters And Recombine In Random Order

This Formula Challenge originally appeared as Tip #194 of my weekly Google Sheets Tips newsletter, on 7 March 2022.

Congratulations to everyone who took part and well done to the 97 people who submitted a solution!

Special mention to Kieran D., Louise A., Martin H., Jelle G., Karl S., Earl N., Doug S., JP C., Alan B., and others for their ingenious solutions. I’ve shared the best below.

Sign up here so you don’t miss out on future Formula Challenges:

 

Find all the Formula Challenges archived here.

The Challenge Part I: Split A String Into Characters

Question: can you create a single formula to split a string into characters so that each character is in its own cell?

i.e. can you create a single formula in cell B1 that creates the output shown in this example:

Formula Challenge Split String Into Characters

Continue reading Formula Challenge #6: Split A String Into Characters And Recombine In Random Order