Query over function formula in counting total Checkboxes in a row from a table?

ovelzone

Hi, Hope you all doing well?

I hope someone could help me on my query... I am creating a table similar to the one below but with large data, i am using the checkbox as column type and in the end column i wanted to add the total checkboxes ticked in each row. Just wondering if there is a function or a formula i can use to get the total result?

In Excel i used function formula =COUNTA(c1:c5) That counts the number of cells that are not empty in a range. Is there a function formula similar to excel (COUNTA) in Smartsheet i can use?

Any help is much appreciated. 🙂

Many Thanks!

Neil Watson

@ovelzone the COUNTIF function can be used.

https://help.smartsheet.com/function/countif#:~:text=Counts%20the%20number%20of%20cells%20within%20a%20range%20that%20meet%20a%20criterion.&text=The%20group%20of%20cells%20to%20count.&text=The%20value%20that%20determines%20which,!%22%2C%20or%20%3E25.

The criterion you are looking for is "1" to count the checked boxes.

Nic Larsen

Try: =COUNTIF([Mod1]@row:[Mod5]@row, 1)

Neil Watson

@ovelzone the COUNTIF function can be used.

https://help.smartsheet.com/function/countif#:~:text=Counts%20the%20number%20of%20cells%20within%20a%20range%20that%20meet%20a%20criterion.&text=The%20group%20of%20cells%20to%20count.&text=The%20value%20that%20determines%20which,!%22%2C%20or%20%3E25.

The criterion you are looking for is "1" to count the checked boxes.

Nic Larsen

Try: =COUNTIF([Mod1]@row:[Mod5]@row, 1)

ovelzone

@Nic Larsen Sorry i was off work yesterday i tried your COUNTIF function and did work, Thank you so much! Appreciate your time. Have a good day. 🙂

ovelzone

https://community.smartsheet.com/discussion/comment/382715#Comment_382715

@Neil Watson It did work by using COUNTIF function. Thanks for the advise. Have a good day!