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?
This should work
=COUNTIFS([Task 1]1:[Task 3]1, HAS(@cell, "A"))
©2022. All Rights Reserved Smartsheet Inc.