Custom Cell Validator

Custom Cell Validator

Posted by: kbj on 24 December 2019, 2:28 am EST

• 

  kbj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 December 2019, 2:28 am EST

  Hi,
  
  Is it possible to build a cell validator that will use the cells location to perform validation?
  
  My situation is this, I would like to make sure a cell value say an “ID” is used only for the row that the cell is in. If another row uses the same ID or the ID exists in a list outside the sheet, the validation would fail.
  
  -Kingman

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 December 2019, 3:51 pm EST

  Hello,

  If another row uses the same ID
  
  There is no direct method for this. You need to iterate the whole column if the particular id already exists in the cell in the edit event of the spread

  the ID exists in a list outside the sheet
  
  For this, you can use the “DataValidation” or “IncludeListValidator” to show the error if the given value is not present in the list.

  Thanks,
  
  Mohit