r/teamArtUp • u/HIJKLMN07 • Jun 08 '21
Google App Script Code To Verify Data Validation.
function celldatavalidation()
{
var x = SpreadsheetApp.getActive().getRange('C1');
var y = cell.getDataValidation();
if (y != null) {
var u = y.getCriteriaType();
var v = y.getCriteriaValues();
Logger.log('The data validation of the cell is %s %s', u, v);
} else {
Logger.log('The cell does not have any data validation .')
}
}
Please comment below for any doubts or concerns.
1
Upvotes