Query over function formula in counting total Checkboxes in a row from a table?
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!
Best Answers

@ovelzone the COUNTIF function can be used.
The criterion you are looking for is "1" to count the checked boxes.

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

@ovelzone the COUNTIF function can be used.
The criterion you are looking for is "1" to count the checked boxes.

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

@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. 🙂

@Neil Watson It did work by using COUNTIF function. Thanks for the advise. Have a good day!
Help Article Resources
Categories
Check out the Formula Handbook template!