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.

Counting Checked Boxes

Options
J.Rapp
J.Rapp
edited 12/09/19 in Archived 2017 Posts

I am trying to sum up the total number of boxes that are "checked" in a row. I would like to set it up so I have a cell in column 4 row 2 with the total number of checked boxes in that same row. Is that possible?

Comments

  • Ryan Caines
    Options

    I believe this is the formula you are looking for. Just change where it reads "Insert_Column_Name_Here" to the actual name of your column with the check boxes.

     

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

  • Ryan Caines
    Options

    I have this setup on one of my sheets and it works as it should. Is the column property type you are referencing "Checkbox" and the column you are inserting the the formula is Text/Number?

  • J.Rapp
    J.Rapp
    edited 01/17/17
    Options

    That would be correct. Do I need to change the properties? And as for my previous comment I made a mistake. I am only getting a return of "0" and there are multiple boxes checked.

  • J.Rapp
    Options

    Problem Solved! I don't know how this worked, but I basically just deleted and re-wrote the function. I originally had the same function you provided, and was only getting "0" as a return value. I didn't really do anything different the second time aside from clicking and dragging to highlight the appropriate range instead of manually typing them in. Im not entirely sure how or why anything changed, but for some reason in the "second_column_name" the brackets were removed and the function works now. I appreciate your help though. Hopefully, this helps someone else. 

  • J.Rapp
    Options

    Thanks for replying. I had previously tried that and it just returns "UNPARSABLE."

    EDIT: Sorry, I messed up my function with an additional parenthesis and didn't realize it at first. However, that was the reason for the "UNPARSABLE" response. When corrected I was still getting a return of "0."

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 01/18/17
    Options

    J.Rapp,

     

    The way I read the question, you are looking for a HORIZONTAL sum of check boxes in a row.

    The answer from Ryan appears to be VERTICAL.

     

    If HORIZONTAL, then the syntax should be

     

    =COUNTIF([column1]rownumber:[column2]rownumber,1)

     

    where

    you are looking for checkboxes between (and including) the columns [column1] and [column2] for the row number entered.

     

    A real example:

    =COUNTIF([Task]23:[Data Delivered]23,1)

     

    for all the columns between [Task] and [Data Delivered] and row 23.

     

    Note that if there is a number value of "1" in a column in the range, that is added to the count too.

     

    Craig

     

     

  • JWoodard
    Options

    Say i would like to count checkboxes in a row depending on the value of a cell in the same row.

    I have several guys on my team answering weekly questions (checkboxes) through a form. I would like to have these totaled cumulative and also within a specific time frame (all answer in the last week).

     

    Capture.JPG

  • Pam Grant
    Options

    I would like to count checked boxes in non-sequential cells in the same row.

    This is my formula for row 1: =COUNTIF([Completed 1]1, [Completed 2]1, [Completed 3]1, 1)

    My error message is "incorrect argument set"

    Help?

    Thanks

  • Pam Grant
    Options

    This formula ended up working for me.

    =COUNT([Column Name 1]1, [Column Name 2]1, [Column Name 3]1)

     

This discussion has been closed.