Check the Checkbox on multiple lines together

Alma PMAlma PM ✭✭✭✭✭
edited 12/09/19 in Using Smartsheet
02/08/18 Edited 12/09/19

Hello everyone

I would like to know if it is possible

Check the Checkbox on multiple lines together

Comments

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

    Hi Alma,

    Depending on what you mean.

    You can select multiple checkboxes and mark one and all the others will also be checked.

    You can also have formulas that check a checkbox if another is checked.  

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant / Get Done

    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.

  • Alma PMAlma PM ✭✭✭✭✭

    The first option helped

    Thanks

    :)

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

    Great!

    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.

  • @Andree - Is there a formula to accomplish the above?

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

    @Harley Esguerra

    Hi Harley,

    Yes, here’s an example using a Parent. When the parent checkbox get checked, all children will also get checked if you use the below formula.

    =PARENT()


    This one would look at a specific cells and if it gets checked, all cells with the below formula would get checked.

    =$Completed$1


    Make sense?

    Would that work?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    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.

  • Yes thank you this helped.

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

    @Harley Esguerra

    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.

Sign In or Register to comment.