Change Dropdown Items in Form

Is there a way to automatically remove a dropdown option from a form after it has be selected a certain number of times?

I have a registration form and have people selecting a time slot and after that time slot has 6 participants I want that time slot to no longer be available.

Find more posts tagged with

Comments

Mike Wilday

This is not possible within smartsheet. And I am uncertain whether a third party solution is available that can do this.

Mike Wilday

Please consider submitting a Product Enhancement Request.

Arez

Since forms are run from sheets, I would think there would be a way to do this at the sheet level somehow. I wish I could give you a better solution, but I'm only 6 months in to smartsheet.

Look into IF functions and a way to make it hide the time slot once a certain number of submissions (rows),

Mike Wilday

Arez is partially true. Forms populate sheets and can pull dropdown option from the master columns in Sheets but the main purpose of forms is to collect information and the ability to adjust forms based on the sheets is just not baked in as far as I know.

Andrée Starå

Hi Kathryn,

If you have developer resources, it's possible with the Smartsheets API.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Mike Wilday

Hi Andree... you can adjust what is available in a form using API? Please share this documentation. That is strange but cool.

Andrée Starå

Hi Mike,

Not in the form but int the dropdown list. That list would then become available in the form.

Mike Wilday

Wow, that is fascinating. Gonna have to look into that.

Sign in to join the conversation!

Quick Links

Trending discussions

Cannot access my smartsheets
Notifications Currently Experiencing Issues?
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…
Dependencies not updating the activities
Hello, The SmartSheet seems to be locked with predecessors dependencies not updating start date of activities. Also the duration does not seem to update the end date. So all needs to be done manually. This was working last week but seems deactivated. How can I reactivate it? Thanks