formula help

Jason Jordan
Jason Jordan ✭✭✭✭
edited 08/05/21 in Formulas and Functions

I have 2 columns i'm trying to count information one is drop down where I need to count rows where a checkbox is checked. I have the formula to find the locations in the columns which works by itself. However; I'm having trouble how to add to count the rows where a checkbox is checked that has either of the location listed in the drop down. The check box column is called "physician leadership" this is for a sheet summary. how do i add additional formula(and what is it) to get the formula to count the checked boxes.

=COUNTIF(Location:Location, OR(CONTAINS("Brock", @cell), CONTAINS("Princess Anne", @cell)))

i've tried to use AND(physician leadership: physician leadership,1) but keep getting error.

Please help.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!