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 CE1234Chiller. 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
Answers


Hi @Reese,
Upon second read of your post, I now see you want the row to equal the instance number and not the number of instances. Sorry, my solution solves only for the number of instances. I'll do some testing to see if I can help with your instance number. Otherwise maybe someone else might chimein in the meantime.

Thank you, @Ray Lindstrom ! It's been driving me mad for the last day. You are right about needing the instance number. I appreciate the help!
Help Article Resources
Categories
Check out the Formula Handbook template!