Allow date in cell but only when all other cells complete

Options

Good morning,

This question may have been asked many times, so apologies if so, but is there a way to stop a user entering a date into a cell until all the other cells in that row have been completed and filled in.

This would then stop the row being moved to another sheet partially complete, because that cell is the trigger for the automation.

Many thanks

Answers