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

CodePudding user response：

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.

CodePudding user response：

Based on the documentation of Google here.

In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include).

So essentially, using TRUE or FALSE in a formula is already using checkboxes. The checkboxes that you see are a graphic representation of TRUE or FALSE when used in a formula you cannot use a graphic representation, and that is why you need to use TRUE or FALSE.