Smartsheet count function

AnyaEdgell

I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?

Paul H

This should work

=COUNTIFS([Task 1]1:[Task 3]1, HAS(@cell, "A"))

https://help.smartsheet.com/function/has