title: Data Validation changing another Data Validation cell
body: <p>In the example sheet below. On Sheet 2 When the drop-down under "Client Remarks" changes to "Finalized By Client" I need Sheet 1 "Course Status" to change to "Finalized By Client". I tried this array formula   </p>
  
  <pre><code>=ARRAYFORMULA(IF('Courses | Client Review'!A4 ="Finalized By Client","Finalized By Client",))
  </code></pre>
  
  <p>but I lose the drop-down menu and I need that to be there. Any help would be appreciated. </p>
  
  <p>Example Sheet: <a href="https://docs.google.com/spreadsheets/d/1GqCv9vgzLYDKg9VcaJn9__8789N9rABH49-9CozGUHU/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1GqCv9vgzLYDKg9VcaJn9__8789N9rABH49-9CozGUHU/edit?usp=sharing</a></p>