Automate the selection of values from a Multi-Select Dropdown

Good day

I am trying to select values from a Multi-Select Dropdown by using an IF formula. Is this possible?

I dont want to manually have to select the applicable values from the multi-select dropdown selection, but instead the formula should select the multiple values in the dropdown.

Regards,

Pierre

Best Answer

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    It could be possible. Are you able to provide more detail as to your workflow? Screenshots with sensitive/confidential data removed, blocked, or replaced with "dummy" data would also be very helpful.

  • Pierre Mostert
    Pierre Mostert ✭✭✭✭

    Hi Paul

    I have attached a screenshot.

    Typically I would like the formula to select 'a' only when checkbox 'a' has been checked. Then when checkbox 'b' has been checked, 'b' should then be included as part of the completed milestone selection.

    Thanks for the assistance.

    Thanks!

    Regards,

    Pierre


  • Pierre Mostert
    Pierre Mostert ✭✭✭✭

    Hi Paul

    Thanks for your response.

    Yes it works great, thanks for all the assistance.

    Just a question, is it possible to instead be selective which columns to look at, instead of a continues range of cells? So for example if my helper row is in a different reference sheet, I would need to keep both the sheet columns consistent else I will receive an #INCORRECT ARGUMENT SET.

    Otherwise all works great.

    Kind regards,

    Pierre

  • Pierre Mostert
    Pierre Mostert ✭✭✭✭

    Hi Paul

    Thanks again for all the help. No worries about my previous question.

    Kind regards,

    Pierre

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!