Adding only children rows that have check box

Hi Everyone,

I'm developing a sheet to track mileage on person vehicles. I have a parent row that totals the number of miles per month, and the children rows show each individual trip. I have a check box at the right to show when a trip has received approval from a supervisor. My question is: how do I get the formula in the parent row to total only those children rows where the checkbox is checked? I have tried several different formulas, but I keep getting Unparseable. Any help would be appreciated!

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!