Remove a dropdown option , if it is already selected

shar

Surprised, this does not exist yet in smartsheet.

I am creating a sheet , All I want to do is once a timeslot has been selected by a customer, the timeslot should no longer appear in the dropdown or hide it or make it un selectable.

I am happy to explore the automation workflow option too, but there is no way to configure either.

I appreciate your solution in this regard asap.

Paul Newcome

Do you have access to the premium app Data Shuttle?

Andrée Starå

Hi Shar,

I hope you're well and safe!

It's possible with the Premium App, Data Shuttle, but it will not be instant.

Would that still work?

Is that an option?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

shar

sure , that works. Pls let me know the process for premium app option and how to configure it. I need to make this work asap.

appreciate your help

Andrée Starå

@shar

I'd be happy to help, but I need some more information.

Feel free to reach out through a pm or at andree@workbold.com

Paul Newcome

My suggestion would be to create another sheet that has each of the options listed going down a column. Then in the next column you would use a basic COUNTIFS with a cross sheet reference to count how many times that selection has been made.

Then you would set up an Offload workflow through data shuttle to grab this list filter to only grab those rows where the second column equals zero (meaning it has not been selected).

Next you would create an Upload workflow through data shuttle to grab the data in the .csv file created by the offload and have it set to update the options in the dropdown column on the original sheet.