Dropdown Multi select - ~If formula

Jose da Silva
Jose da Silva ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi all,

 

Been searching about this, but could not find anything so far. Hopefully you can help me.

I am just starting to make use of the multi select dropdown list.

So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a single column for each of the options from the dropdown. What i need to do is use a formula on each of those that basically applies the following logic -> "if this valie is ticked on the multi drop, then also tick it here"

 

How would that work?

 

Thanks in advance.

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Jose,

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    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.

  • Jose da Silva
    Jose da Silva ✭✭✭✭✭✭

    Hi Andree,

     

    See below the screenshots.

    All i need is for the information that is ticked on the multidrop list to be duplicated to the individual columns (will have a column with tickbox for every option on the multidrop).

    Do you know any good formula solution?

    multidrop.png

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I would suggest using the CONTAINS function.

     

    =IF(CONTAINS("insert text here", [Docs Checklist]@row), value if true)

    thinkspi.com

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Try something like this.

    =IF(CONTAINS("NDA"; [Docs checklist]@row); 1)

    The same version but with the below changes for your and others convenience.

    =IF(CONTAINS("NDA", [Docs checklist]@row), 1)

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?

    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.

  • Jose da Silva
    Jose da Silva ✭✭✭✭✭✭

    Hi all, Thank you for your help.

    It does work. Just a small correction on your formulas (just the p[lacement of a bracet):

    =IF(CONTAINS("insert text",[Docs Checklist]@row),1)

     

    Again, thanks all!!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    Happy to help!

    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.

  • Mike Bumpus
    Mike Bumpus ✭✭✭✭✭
    edited 04/23/21

    Is this deprecated somehow with the addition of the Column Formula? Doing almost the exact same thing and getting #INCORRECT ARGUMENT SET


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Mike Bumpus

    That error has to do with the structure of your formula. The CONTAINS function first has the value you're searching for, then the range. After these are listed you want to close off the function: )

    Try this:

    =IF(CONTAINS("Video", [Actual LOB]@row), 1)


    Now, since you're looking at a mutli-select column I would suggest using the HAS function instead, like so:

    =IF(HAS([Actual LOB]@row, "Video"), 1)

    Cheers!

    Genevieve