Check Boxes - images instead of True False values

Question

I have created a dependent drop-down list for my data but I would like to know if there is when filtering my original data to get the values in col F, G, and H as a check box instead of True and false values. I would appreciate any help to solve this issue. Best, here is the link to the spreadsheet.

https://docs.google.com/spreadsheets/d/1cCG3eVUCxSPNIXQJExX0CAT6cGEnMq0qOQfOjogw8RY/edit?usp=sharing

Answer 1

Select one of the cells you expect to display those true and false values and choose Insert > Checkbox to format the cell as a checkbox. Then set the value in that checkbox cell null by removing the false value in the formula bar. Finally, copy the checkbox across the row and down as far as necessary.

See your sample spreadsheet for an illustration.

To hide "unneeded" checkboxes in rows where there is no data yet, use a conditional formatting custom formula rule to set the text color of the cell to match cell's fill color when the row is blank. That will make a checkbox invisible.