Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Booleans

Jackie Jones
edited 12/09/19 in Archived 2016 Posts

I need the formula for counting the checkboxes in a column.

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    The whole column?

     

    =COUNTIF([ColumnNameHere]:{ColumnNameHere],1)

     

    Craig

  • Jackie Jones
    edited 03/16/16

    Its comog up unparseable. Did find this formula ="" + COUNTIF(CHILDREN(), 1) to add up the booleans.  Now I need these numbers to make a total at the top.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Oops.

     

    =COUNTIF([ColumnNameHere]:[ColumnNameHere],1)

     

    I'm not sure how that curly brace got there.

     

     

    CHILDREN will only work the rows that are indented. If you have more than one section (parent row) then it won't grab the whole column, only parts - which is also useful in some cases.

     

    By adding the "" you have changed the count (a number) to text and may have difficulty doing more math on them if you need to.

     

    Craig

     

This discussion has been closed.