1

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

player0
  • 124,011
  • 12
  • 67
  • 124
user610125
  • 13
  • 3

1 Answers1

0

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

player0
  • 124,011
  • 12
  • 67
  • 124
  • This looks very impressive. I like your trick. Is there a way to wrap it in the query function because I need to select certain columns not everything? Thank you so much for your help showing the header as well. – user610125 Oct 13 '22 at 23:05
  • @user610125 query does not support pictures but filter is as powerfull as query – player0 Oct 13 '22 at 23:07