title: Returning a value if there is an specific match
body: <p>I'm working on an smal project on which I have to analyze orders if the were fully completed or not. In the column "status" I have the raw data pulled from my reporting tool with the tags "completed" or "INCOMPLETED". In the column Review I want to enter a formula that will return INCOMPLETED because one or more lines within the same order# was not completed. Any suggestions wil do. THX.</p>
  
  <p><a href="https://i.stack.imgur.com/8u6Ao.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8u6Ao.png" alt="enter image description here"></a></p>