Smartsheet count function

AnyaEdgell · 03/21/22

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 · 03/21/22

This should work

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

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

Smartsheet count function

Answers

Help Article Resources

Categories