Formula for a checkbox column

JennS_
JennS_
edited 12/09/19 in Smartsheet Basics

I have searched all the forums for the formula for the checkbox sum & none of them have worked for me. I need to total the sum of the checkboxes that are checked within a column.

 

 

 

 

Capture.JPG

Tags:

Comments

  • pkitzens
    pkitzens ✭✭✭✭✭✭

    I just needed to do this today. 

    enter '=COUNTIF', then select the entire column, and put '1' for checked. 

     

    =COUNTIF({On Track}, 1)

  • I don't know why, but its not working for me.  I've tried this several times. I either get "unparseable" or Boolean Exp message.

     

  • It worked if it is not in the same column as the checkboxes! Is there a way to make it part of the same column so the totals are below the boxes?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    If you make all of the lower rows Child rows (indent them) below the summary row, you could use...

     

    =COUNTIFS(CHILDREN(), 1) + ""

    thinkspi.com

  • @Paul Newcome this formula helped me tremendously! Now I am facing another challenging. I am now trying to SUM the COUNTIFS totals using a CHILDREN formula to show the overarching total. I have attached an image. When I just try a general =SUM(CHILDREN( formula, nothing populates in the cell and I still see the checkbox. When I tried totaling manually at one point, instead of a SUM I somehow merged the numbers into a string (i.e. instead of 5 + 4 + 1 creating 10, I got 541).

    Any suggestions on how I can total up the 23 + 17 + 1 + 0 + 0 + 0 appropriately in the North America row?


  • @Jen V I am at a similar situation. Did you find a way to sum in the checkbox column?

    Thanks in advance.