Count Checkboxes Help please

Caroline Dunnell

Hi, I need to know the formula to work out how many check boxes are ticked under a parent row.

We have 3 Teams - Team 1, Team 2 & Team 3 and I need to see how many Live Projects they all have as I am building a Dashboard.

But in order to get the metrics on this I need to know how many live projects. I have a tick box under each parent row of "Team 1" etc, but what formula would I use to count how many tick boxes are ticked?

Caroline Dunnell

Thank you - I adapted both comments to help me and I got it working.

I used:

=COUNTIF(CHILDREN([Live Project]@row ), true)

Thank you everyone

Clarity Ava

Not 100% sure if it works but it's worth trying:

Add a helper level column with:

=COUNT(ANCESTORS()) + 1

Then:

=COUNTIFS(Level:Level, 1, [Live Project]:[Live Project], 1)

Let me know in both conditions, whether it worked or not!

Andrée Starå

https://community.smartsheet.com/discussion/140771/count-checkboxes-help-please

Hi,

I hope you're well and safe!

Try something like this.

=COUNTIFS([Live Project]:[Live Project], 1)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Caroline Dunnell

Thank you - I adapted both comments to help me and I got it working.

I used:

=COUNTIF(CHILDREN([Live Project]@row ), true)

Thank you everyone

Andrée Starå

https://community.smartsheet.com/discussion/comment/489005#Comment_489005

Excellent!

Happy to help!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏