Count if

Karrie Davis
Karrie Davis Overachievers Alumni

Hi I'm wondering if someone could assist me. I writing a count if for a column and it isn't counting the item if there is more than one answer in a row. Example would be =Countif([Case Type]:[Case Type], ="Birth Certificate". If you see below where Birth Certificate and SSI are in the same row, my formula is not counting that Birth Certificate its is giving me answer of 3 instead of 4.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!