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.

COUNTIF where cell contains checkmark EXAMPLE

E Frank Kurtz
edited 12/09/19 in Archived 2016 Posts

Need a 'countif' example, where cell contains a checkmark?

Comments

  • Greg Gates
    Greg Gates ✭✭✭✭✭

    When a box is checked it has a value of 1, so you just need to write a formula like this to count the number of checked cells:

     

    =COUNTIF([Checkbox Column 1]1:[Checkbox Column 1]8, 1)

  • E Frank Kurtz
    edited 08/31/16

    Laughing That worked!  Thanks!

    Another observation.  Cannot locate formula  in a column that is formated with properties as a 'check box'.     

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭

    Edward,

     

    almost correct :)

     

    Since the  "check box" columns have boolean values (Yes/No or 1/0), there cannot be a formula like the one Greg suggested (you'll get a warning #BOOLEAN EXPECTED). You must locate these formulas in another (text/number type) column.

     

    However, you may write an even more complex formula if the outcome is 0 or 1:

    =IF(COUNTIF([Checkbox Column 1]1:[Checkbox Column 1]8, 1)>1, 1, 0)  [it will be checked if more than 1 checkboxes are checked in the range].

     

    Atus

     

     

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

    If what you are hoping for is the number of checkbooks are checked and display in the same column, then you can convert the result to text, which the check box column will accept

     

    =countif (as above) + ""

     

    will display the count.

    Watch out for circular references... if the formula is in row 1, the formula should not try to count it.

     

    Hope this helps.

     

    Craig

  • Tribeiro
    Tribeiro ✭✭✭

    Greg, does this formula still applies for the latest smartsheet update? also, what does that number 8 stands for?

     

    I am sorry, I am just new at this.

     

    Thank you

    TJ

This discussion has been closed.