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
Jackie Jones ✭
edited 12/09/19 in Archived 2016 Posts

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

Tags:
· Share on FacebookShare on Twitter

Comments

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

    The whole column?

     

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

     

    Craig

    · Share on FacebookShare on Twitter
  • Jackie Jones
    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.

    · Share on FacebookShare on Twitter
  • 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

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories