Using COUNTIFS and two CONTAINS
I've read most of the answers and using the recommendations, I'm still getting the error #UNPARSEABLE
This FORMULA works, but I need to add another search for "DC"
=COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell)))
so I've add another COUNTIFS and CONTAINS but it's giving me an error. Also, tried variations and neither works. This FORMULA is the one that returns #UNPARSEABLE:
=COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell))), + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("dc", @cell)))
Any help would be greatly appreciated.
Thanks so much!
Best Answers
-
Looks like a syntax error. You have an unnecessary comma.
Try the corrected formula.
= COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell))) + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("dc", @cell)))
-
Hi @Tiffany Sablan
Hope you are fine, please try the following formula ( and you can add as much as you need of the searching criteria in the Criteria column after you converting the formula to column format formula:
=IF(ISBLANK(Criteria@row), "", COUNTIFS([DC - Status]:[DC - Status], HAS(@cell, Criteria@row)))
the following screen shot shows the result
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Looks like a syntax error. You have an unnecessary comma.
Try the corrected formula.
= COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell))) + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("dc", @cell)))
-
Hi @Tiffany Sablan
Hope you are fine, please try the following formula ( and you can add as much as you need of the searching criteria in the Criteria column after you converting the formula to column format formula:
=IF(ISBLANK(Criteria@row), "", COUNTIFS([DC - Status]:[DC - Status], HAS(@cell, Criteria@row)))
the following screen shot shows the result
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
@Toufong Vang Thank you so much! That did the trick. @Bassam Khalil I went with the original formula but this example was extremely helpful for another formula I was trying to solve. I appreciate both of your quick responses.
-
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!