CODEWITHSUNDEEP
google-sheets
user1592380
user1592380

Reputation: 36317

Checkable checkbox column in sheets

enter image description here

I'm trying to create an column of checkable boxes in sheets, 1 for each row. I have placed an array formula in A2:

=ARRAYFORMULA(IF(ISBLANK(B2:B),"","☐"))

However although this produces the correct number of boxes in the column, they are not able to be checked/unchecked individually . How can I get this working?

Upvotes: 1

Views: 41

Answers (1)

player0
player0

Reputation: 1

  • highlight the range
  • insert checkboxes

  • highlight the range
  • go to conditional formatting
  • add custom formula for A1:A range =IF(NOT(LEN(B1:B)), 1)
  • select white background
  • select custom color for font: #fffffd

Upvotes: 2

Related Questions