Formula for a count of checkbox by a specific location



I am trying to create a formula for a specific location and completed check box. Here is my formulas. Each work separately but as I am trying to join, it does not work.

=COUNTIFS((Attended:Attended, 1),(Location:Location, "Cedar Crest"))

Thank you in advance for assistance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!