title: If text contains "Quartal" or "Year" then do something - google docs
body: <p>I am working on a google docs sheet, currently trying to automate most of the data entry. I want to do an action if a text is found in a cell.</p>
  
  <p>Have a look at this sheet:
  <a href="https://docs.google.com/spreadsheet/ccc?key=0AlfftUoJOAjCdGp0Z2stbmhncGs0bFE5ZU43dkFLVEE#gid=0" rel="nofollow">https://docs.google.com/spreadsheet/ccc?key=0AlfftUoJOAjCdGp0Z2stbmhncGs0bFE5ZU43dkFLVEE#gid=0</a></p>
  
  <p><strong>I have those scenarios:</strong></p>
  
  <ol>
  <li>Monthly -> Indicated by number. Pseudo-code: if number.</li>
  <li>Quarterly -> Indicated by "Quarter". Pseudo-code: if text contains "Quarter"</li>
  <li>Yearly -> Indicated by "Yearly". Pseudo-code: if text contains "Yearly"</li>
  </ol>
  
  <p>How can I check each of the three scenarios in Google docs?</p>