Can I create a drop down list which will remove one choice after it is picked?

Hello -

I have a form that I use drop down choices for delivery times at my place of business. I would like to upgrade to the business version but need to make sure this will work for me before proceeding. Currently multiple delivery time choices can be taken but I only want to show the times available. For instance, we have open appointment times at 6am, 7am, 8am, 9am and 10am. If the form is filled out to reserve the 9am appointment time, I would like the form to only show 6am, 7am, 8am and 10am. Is this possible?

Find more posts tagged with

Conditional Formatting

Accepted answers

All comments

Melissa Yamada

Hello @Brian W.

That feature isn't available yet.

You can check this community thread and see if this will help with your solution:

https://community.smartsheet.com/discussion/73363/appointment-booking-smartsheet

Brian W.

It just seems to me there has to be an If/Then that could fill cells in another sheet or outside the form cells that are used

Melissa Yamada

@Brian W.

You can create that workaround as well but you'll need the add-on app which is Data Shuttle to automatically update your dropdown options.

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.