I would like my target completion column to have a date that is greater than in my start column. Excel supports a date validation option but I do not see this in Google Sheets.

Is it there and I just don't know how to use it or is my only option to write an Apps Script add-on?

  • Please don't post the same question across sites on Stack Exchange. – Rubén Nov 11 '16 at 13:50

It is easy with a specific date but I think would require a script if to apply on a row by row basis (a moving target for the comparisons).

An alternative is to apply Conditional formatting... instead (to warn of but not prevent inappropriate entries).

|improve this answer|||||

Not the answer you're looking for? Browse other questions tagged or ask your own question.