Count number of checked in a sheet

Options
SmartStian
edited 12/09/19 in Formulas and Functions

Hi

 

Could tou please help me to count the nuber og checked rows in a sheets without making parent, children rows?

Smartsheets - Count checked.jpg

Comments

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

    Hi (Hej),

    You must add a so-called helper column that will check if the row is a parent or not and then use that in the formula that's counting the checkboxes.

    Would that work?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • SmartStian
    Options

    Hi Andrée

     

    Thank you so much for responding that quick :-D

    I did not understand that. I think it is weird that you have to make help columns to count the number of checked boxes in a coulumn. I share the sheet with you.

     

    I want to sum up the number of checked boxes i these two coulmns:

    Gjennomgått HMS-ansvarlig and Lukket HMS ansvarlig.

     

    Take a look at the photo :-D

     

    I am going to use these values in a future dashboard.

     

    Best regards

     

    Stian

    Smartsheets - Count checked, 1.jpg

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

    Happy to help!

    I misunderstood your question. You don't need a helper column. I've added the information to your sheet.

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • SmartStian
    edited 02/13/19
    Options

    Hi Andrée

    I am so happy thtat you can helpt me :-D

    I am new to smartsheets, but I have already fallen in love with the program :D

    I can see that you can not put the formula in the cell on the top of the respective column because it has the status as checbox?

    Thanks again!

    Best regards

     

    Stian

     

     

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!