If condition for Multiple Checkbox

chetanpuranik
edited 12/09/19 in Smartsheet Basics

Hi,

I have a form with Multiple Checkbox and I would like to display Checkbox header if selected. If multiple checkbox selected , would like to display combination of those checkboxes selected.

Pls help at the earliest.

Thanks,

Chetan.

Comments

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

    Hi Chetan,

    Can you describe your use case in more detail?

    Best,

    Andrée Starå - Workflow Consultant / Get Done

     

    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 for help with Smartsheet, integrations, general workflow advice, or anything else.

  • chetanpuranik
    edited 01/23/18

    Hi,

    Thanks for checking on this.

    Here is the use case,

    I have a smart form where I have checkbox to select TYPE of things. Now in my smartsheet , I want 1 column to display the Selected Option / options from the checkbox selected in the form.

    If we are using checkbox means , the user can select multiple options in the form , the same needs to be displayed in a consolidated column in the smartsheet.

    How to display this consolidated selections in a column in smart sheet. 

    what kind of  IF formula should i use to say , if Option 1 is selected and Option 2 is selected, Option 3 is not selected, the column used to display this selected options should says ( Option 1 + Option 2).

    Hope this explaination helps.

    Thanks,

    Chetan.

     

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 01/29/18

    Hi Chetan, 

    Here is an example on how you could set it up. Would this work for you?

    https://cl.ly/p9Ta

    Below you have the formulas so that you can copy them easily.

    =IF([Doc 1]1 = 1; "1") 

    =IF([Doc 2]1 = 1; "2")

    =IF([Doc 3]1 = 1; "3")

    =JOIN([1res]1:[3res]1; "+")

    Please see attached link/screenshot.

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant / Get Done

    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 for help with Smartsheet, integrations, general workflow advice, or anything else.