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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!