Hello,
I have a column on a spreadsheet which uses a list from a second sheet and data validation to only allow those values to be used.
What I want to do, is in the list, if a certain list value is used more than twice, I was the spreadsheet to throw an error and decline the use, so only one value can be used twice.
Is this possible?
Cheers.
I have a column on a spreadsheet which uses a list from a second sheet and data validation to only allow those values to be used.
What I want to do, is in the list, if a certain list value is used more than twice, I was the spreadsheet to throw an error and decline the use, so only one value can be used twice.
Is this possible?
Cheers.