I'm trying to solve this problem in Google Sheets. I have a Data Validation based droplist on column A (each row contains new droplist). I need it to be visible only when all of the checkboxes ABOVE it in column F are TRUE. If they are FALSE, then I need the A column droplist to be invisible/ blank. If user would select all checkboxes, the A column droplist would become visible again.

Example:

CodePudding user response：

Here's a non script-based approach. As per your example file:

• In A1:A4, change the data validation drop down range to D1:G4
• Retain tick boxes in B1:B4
• In D1, enter the formula =arrayformula(ifna(if(match(FALSE,B1:B4,0)>row(B1:B4),na(),),{"ABC1","ABC2","ABC3","ABC4"}))

This approach results in the validation range only being populated for each row if all checkboxes above that row are TRUE, so for any row which is FALSE the validation range is empty.