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