title: Ignore data validation errors in Google Sheets
body: <p>I am using the data validation functionality to create a drop-down menu.  The menu options are populated via the "List from a range" criteria option in the data validation dialog box.</p>
  
  <p>The menu list is really long, so it only lists "available tasks".  When a task is completed, it disappears from the range that the data validation points to, and therefore is removed from the menu.</p>
  
  <p>This then creates the <code>"Invalid: Input must fall within specified range"</code> error, which is true, but because I am using this feature as a dynamic menu rather than actual data validation, I want to ignore it and not see the little red triangles all over my sheet.</p>
  
  <p>Any ideas?</p>