CODEWITHSUNDEEP
javascriptvalidationgoogle-sheetsgoogle-docs-api
Martin Fedy Fedorko
Martin Fedy Fedorko

Reputation: 333

Empty data cell validation

How can I add validation on cell, that checks if the cell is not empty after creating new data record? Something like mandatory fields.

Upvotes: 1

Views: 4680

Answers (1)

pnuts
pnuts

Reputation: 59485

I think this is not possible (in the way I think you are requesting). From here:

If data validation is applied to cells containing data, rules won't be applied until the data is modified.

That does not actually say "No, it is not possible" but I think can be inverted as, "No modification, no trigger for validation" - and I'm assuming your cells start off empty (though for blanks I think it does not actually make any difference).

I suggest considering alternatives, possibly conditional formatting of cells that are empty (there is specific provision for Cell is empty), a formula to count the number of blanks cells in a range that should be populated (since you mention records you might prefer a row to be flagged rather than each individual blank cell), or resorting to a script.

Upvotes: 1

Related Questions