CountIF Formula Conundrum


Hi! I am trying to duplicate the formula in Image 1 using SmartSheet language. The formula in Image 1 is in Excel. What it's doing is counting the number of like instances. So for example, per the image, there are two rows that both have CE-1234-Chiller. We want the formula to identify the first, second, third, and so on, instance of this same naming convention.

The formula I attempted in SmartSheet (Image 2) is producing "1" every time and does not appear to be counting the same naming convention.

Image 1

Image 2


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!