So I need my spreadsheet to have a header row, and every row below be where the data is entered... so I've got that setup fine I think.
Now I need to define validation rules on ranges, so like K2:K40 can only have 1-5... I was able to do this in the widgetCreated event
"PGYs are 1-5"
My current struggle though is being able to find out the total validation errors in the sheet... the code provided here
Always fails, the "cell.validation" in range.forEachCell is always undefined... what am I doing wrong here?