title: Automatically remove from drop down list in google sheets
body: <p>Say that I have a dropdown list based on a column that has &quot;cat, dog and rat&quot; on it, and some lines select the option rat on the dropdown. After that I remove &quot;rat&quot; from the column (so form the dropdown), but the lines that had &quot;rat&quot; on it still with it and a msg saying that this data is invalid.</p>
  <p>Is there a way to automatically remove the selected item that is not at the dropdown anymore? (put it blank maybe)</p>
  <p>Check this image... &quot;LEOBAZEREDO&quot; is not on the list anymore, but his name is there with an alert. I would like that at this line the dropdown become blank when I remove LEOBAZEREDO from the itens</p>
  <p><a href="https://i.stack.imgur.com/Sn5GH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Sn5GH.png" alt="enter image description here" /></a></p>