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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!