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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!