Search code examples
imagegoogle-sheetsfiltercheckboxgoogle-query-language

Filter/Query Check boxes


Is there a way when creating a filter or query function to include the check-boxed columns as is instead of True and False values? Thank you for your help.

https://docs.google.com/spreadsheets/d/15agH1PBFGqpTJn5kZDR9_oKQ5fDQ0ADbU4r8WbJBtMc/edit?usp=sharing


Solution

  • try:

    =FILTER({Sheet1!A2:C8, IF(Sheet1!D2:D8=TRUE, 
     IMAGE("https://i.imgur.com/DgTwvYi.png"),
     IMAGE("https://i.imgur.com/8AxCgKZ.png"))}, Sheet1!A2:A8="Marez")
    

    enter image description here

    enter image description here