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.
Help Article Resources
Check out the Formula Handbook template!