Default value in a cell from dropdown menu?

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!

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.