Auto-fill column when inserting a new row?

[browne09]

I've got a spreadsheet with a hidden 'start date' column. The start date is going to be the same for all tasks that are inserted into the sheet, so I want it to automatically fill this date in when people insert a new row.

Is this possible??

 

[Fluff]

Thanks for the link.
The one on Reddit is
https://www.reddit.com/r/excel/comments/d6dhu0/autofill_formula_when_inserting_new_rows/