Dropdown Multi select - ~If formula

Jose da SilvaJose da Silva ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
10/08/19 Edited 12/09/19

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 PARTNER & CONSULTANT / EXPERT

    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 SilvaJose 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 NewcomePaul 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 PARTNER & CONSULTANT / EXPERT

    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 SilvaJose 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 PARTNER & CONSULTANT / EXPERT

    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 BumpusMike 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


  • 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

Sign In or Register to comment.