#UNPARSEABLE COUNTIFS Formula
I am trying to count two multi-select columns but keep getting UNPARSEABLE error. Do you see an error in my formula?
=COUNTIFS({Issue tracker DSCSA-MDM}, HAS(@cell, "IT"):{Issue/Task}, HAS(@cell, "Issue"))
Best Answer
-
The screen shot suggests there is an issue with the cross references. You should have two cross sheet references and each one should include only one column.
Can you select only the "Source of issue" column, give that a name, and use that instead of {Issue tracker DSCSA-MDM} in the formula.
Then select only the "Issue /Task or monitoring" column, give that a name and use it instead of {Issue/Task} in the formula?
Answers
-
=COUNTIFS({Issue tracker DSCSA-MDM}, HAS(@cell, "IT"), {Issue/Task}, HAS(@cell, "Issue")) This gives me an incorrect argument.
-
The second formula looks good.
=COUNTIFS({Issue tracker DSCSA-MDM}, HAS(@cell, "IT"), {Issue/Task}, HAS(@cell, "Issue"))
Can you try removing and replacing each " in case there are some curved ones in there?
-
I did, and I still get an Incorrect argument. =COUNTIFS({Issue tracker DSCSA-MDM}, HAS(@cell, "IT"), {Issue/Task}, HAS(@cell, "Issue"))
-
The screen shot suggests there is an issue with the cross references. You should have two cross sheet references and each one should include only one column.
Can you select only the "Source of issue" column, give that a name, and use that instead of {Issue tracker DSCSA-MDM} in the formula.
Then select only the "Issue /Task or monitoring" column, give that a name and use it instead of {Issue/Task} in the formula?
-
Thank you, KPH. I renamed the columns, and it worked. Thanks for pointing me in that direction!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!