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