nick
nick

Reputation: 197

Adding text with Tick Box in a single cell in Google Sheets

Is it possible to have a Tick Box followed by some text in a cell in google sheets?
I was able to add the Tick Box but when I add a text along with it, it shows a validation error:
enter image description here

Upvotes: 3

Views: 9334

Answers (4)

Jayce Sausa
Jayce Sausa

Reputation: 11

Just to clarify, is it not possible to put a checkbox beside text in a single cell? I saw that you could create a strikebox, but I don't think that's what the OP meant. Pretty sure he meant the same thing I do.

For example:

TextDescribingCheckbox[Checkbox]

Upvotes: 0

Phil Anderson
Phil Anderson

Reputation: 165

If you're trying to achieve a visual change on the text (e.g. crossing it out when the checkbox is checked) just use two separate columns with conditional formatting based on the value of the checkbox cell. See my example.

The conditional formatting rule is:

Custom Formula Is

=$A2

Where A2 is the top cell in the range with checkboxes.

This produces a result like this:

enter image description here

Upvotes: 1

The God of Biscuits
The God of Biscuits

Reputation: 3207

It's possible to change the value of TRUE/FALSE for any tickbox by using the 'Use custom cell values' option in data validation, however this will only change the value seen in the formula bar; in the cell itself it will just be the usual tick or empty box that is seen.

You could potentially create a dropdown with the two options being '✔️ text' and '✖️ text' but I strongly suspect that there's a bit of an XY problem going on in your description, and that the best option is simply to have a column of tickboxes next to a column of text.

Upvotes: 1

marikamitsos
marikamitsos

Reputation: 10573

Your question is not very clear to me as to what would be your use of the text. In any case.
As an alternative you could add a Note.

enter image description here

Upvotes: 0

Related Questions