Reputation: 197
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:
Upvotes: 3
Views: 9334
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
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:
Upvotes: 1
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
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
.
Upvotes: 0