Default value in a cell from dropdown menu?

Kate Allison

Hi!

I'm creating a tracker sheet for a form. I've added some additional columns to help track the status & other info for the team working on requests submitted via the form. One of the columns is a status column, which as a dropdown menu (options: Not Started, In Progress, Complete, Cancelled).

Is there a way that when a form is submitted, the cell in the status column automatically sets to "Not Started"? And then as the project status changes, I want to be able to switch it to the other values in the dropdown list.

Thanks for any help!

Kelly Moore

Hello Kate

You can default the value to Not Started in your form (and hide this field on the form so it can't overwritten) using Field Settings when you have the Form Editor open.

Note that this default option is only available when using a form - there is not yet Sheet functionality that allows one to default a value from a dropdown list within the sheet.

Kate Allison

Thank you! This did exactly what I needed.