Sheet Summary Help

I think this is probably an easy thing that I am overthinking, but I cannot get the Sheet Summary Formula to work. I need to create a formula to count how many Biltmore Site Home, Biltmore Site Telehealth, Biltmore Site Office, and the same for the other site.

I keep trying iterations of this formula with no success. =COUNTIF(Site:Site, "Biltmore") AND (Condition:Condition, "Home")

See screenshot below.



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!