title: How can I filter my search in a column on google sheet which collects data from a form?
body: <p>I would like to perform a multi criteria search of data in a column- contains data of check boxes(more than one option chosen). </p>
  
  <p>For a clearer picture of what I am trying to do, screenshot below is a question in a form</p>
  
  <p><img src="https://i.stack.imgur.com/Q3FWn.jpg" alt="enter image description here"></p>
  
  <p>Data from the form are saved in sheets like below,</p>
  
  <p><img src="https://i.stack.imgur.com/bLgr4.jpg" alt="enter image description here"></p>
  
  <p>So my concern here is if I would like to search/filter for the rows that contain "<strong>Commercial</strong>", the rows with <strong>Commercial,Engineering</strong> doesn't show up. That's definitely not an effective search. </p>
  
  <p>Any advise on how can I go about this issue is kindly appreciated. If </p>