The general idea is that some requests will require an extension. The extension column is yes or no. Right now the column appears blank unless someone changes it to yes or no. We would like it to automatically appear as no with the option to change it to yes.

We also have a date received and a due date column. The due date column is automatically updated based on the date received column. If "yes" is chosen under extension taken the due date column is automatically extended an extra X days.

Hopefully that gives enough detail.

We have a shared form open to public. As individuals submit the form a new row will automatically be added to the top of our sheet. Formulas are automatically updated as well so everything always auto calculates as a new row is added.

No hierarchy in our sheet.

@Paul Newcome Thank you! go figure it was something so simple.