Smartsheet count function
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?
Answers
-
This should work
=COUNTIFS([Task 1]1:[Task 3]1, HAS(@cell, "A"))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!