Counting Quantities of Numbers

Jason Tarpinian
Jason Tarpinian ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to build a column to count the # of times a predecessor appears in the predecessor column. The below formula has almost gotten me there, but it is also counting predecessor cells that include 1, but not exactly 1 (like 12, 21, 100, etc...)

=COUNTIF(Predecessors:Predecessors, FIND(1, @cell) > 0)

Is there any way to search for exactly 1, or perhaps another way to get my answer I'm not thinking of?


Thank you!

Jason Tarpinian - Sevan Technology

Smartsheet Aligned Partner



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!