title: Change value if column contains value
body: <p>I have a drop down list in column G, and I want to change the current cell (which is J7) if text is found within column G.</p>
  
  <p>This is what I have so far, however it does not work.</p>
  
  <p><code>=IF(FIND( "Fail" , G:G ),"Yes" ,"No" )</code></p>