OR(HAS Function  limits to criteria?
I just learned from a ProDesk session that we needed to use HAS rather than CONTAINS, since will have more than one entry in a cell. However, we have one set of counts for three criteria in a cell. When I added the third one to the formula, it returned Unparsable. Is there a cap on how many HAS criteria you can count?
=COUNTIFS([Program type(s)]:[Program type(s)], OR(HAS(@cell, "EM"), HAS(@cell, "Core"), HAS(@cell, "Tele HM")), Summary:Summary, 0, Level:Level, >1))
Answers

Hey @Tina Rustvold
It looks like you have an extra parenthesis at the end of your formula

Thanks Kelly@Kelly Moore; we adjusted our criteria a bit and now we get an #INVLAID DATA TYPE. These are all references the correct data columns so I am back to wondering if this OR(HAS string has limitations on how many critiera we can add. We are so close!
=COUNTIFS([Program type(s)]:[Program type(s)], OR(HAS(@cell, "EM"), HAS(@cell, "Core"), HAS(@cell, "HM"), Summary:Summary, 0, Status:Status, OR(@cell = "Complete", @cell = "N/A")))

Hey @Tina Rustvold
It's a parenthesis again. Whenever I'm stuck on troubleshooting a formula, I place my cursor in the very last parenthesis and see what it is paired to. I then step backwards in each of the ending parentheses to see all of the pairs This may have helped find the misplaced parenthesis. In your formula above, you did not close off the first OR, which means you have an extra parenthesis at the end.
=COUNTIFS([Program type(s)]:[Program type(s)], OR(HAS(@cell, "EM"), HAS(@cell, "Core"), HAS(@cell, "HM")), Summary:Summary, 0, Status:Status, OR(@cell = "Complete", @cell = "N/A"))
There may be a limitation on the number of HAS functions in a formula, but I haven't hit it yet. It's been my experience when trouble shooting this isn't among the first error options to explore.
Does the formula above work for you?
Kelly
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.5K Get Help
 367 Global Discussions
 202 Industry Talk
 432 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 447 Show & Tell
 29 Member Spotlight
 1 SmartStories
 286 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!