Remove a dropdown option , if it is already selected

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.


Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Do you have access to the premium app Data Shuttle?

    thinkspi.com

  • Andrée Starå
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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å
    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 [email protected]

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul Newcome
    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.

    thinkspi.com