count check boxes

Options

System

System Employee

06/25/24 in Formulas and Functions

This discussion was created from comments split from: Formula to count cells in a column if box is checked.

0 ·

Answers

inacomptsg ✭✭

06/25/24

Can you help with this i am trying to count check boxes on same sheet

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

06/25/24

@inacomptsg Try this:
=COUNTIFS([Demo Complete]:[Demo Complete], @cell = 1)

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter
inacomptsg ✭✭

06/25/24

Your Awesome Thank you

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

06/25/24

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Leave cell blank
Can someone help me update both of these formulas to leave the cell blank if the total is 0? Thanks =SUMIFS({Award Total}, {Grantor}, Grantor@row , {FY Awarded}, [FY22]@row , {Status}, HAS(@cell , "Awarded"), {Funding Source}, HAS(@cell , "Federal")) =SUM([FY22 Total]@row , [FY23 Total]@row , [FY24 Total]@row , [FY25…
Multiply fields with formulas
I have 2 cells that I would like to take the output of the formula in each cell and multiple. I did the standard formula in the Pay cell but I am guessing due to my formulas in the other cells is causing an issue. Pay rate formula: =IF([Client Name]@row = "Weekend Stay", "$150") Total Hours formula: =COUNTIFS([Saturday…
Count If formula using cross sheet reference
I've inherited a massive sheet and leadership has asked that it not be modified. There are 5 "actions" per row. I'm trying to count if any of the 5 actions are classified as "high" significance. The goal is to chart the number of "high" actions by function. =COUNTIFS({DD Input sheet - system team function}, "franchise",…