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
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
