Setting up the best formula

Hi all

Can someone please help me. I am new to setting up formulas and have been successful in doing a number of them on my smartsheet already however for some reason my brain has gone dead and I cannot figure out a formula.

I have a column which is a checkbox, I want a formula set up to notify me how many have been ticked. So far I got COUNT(CHILDREN([Todays Date]196:[Todays Date]207)), however I don't know what to put for it to count the checked boxes.

Please can some advise me or tell me I am wayyyyy off track with this??



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!