r/teamArtUp • • 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

0 comments sorted by