How to autofill a single cell when a new row is added?

Options

Our team uses a sheet to track our projects. One of the columns in the sheet is an Award Status column with dropdown options. When a new row is added, I want the default to be set to Pending. How would I go about doing that?

Answers