Wildcard workaround
Hi,
Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability. Below if my code:
=COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published")
How would I edit this to correctly capture the count? Thanks!
Best Answer
-
Yes, wildcards are badly needed. There's an enhancement request in Community that I encourage you to vote for.
That said, you can use CONTAINS often to accomplish what you need. Your formula would adjust to look like this:
=COUNTIFS({Papers Range 2}, CONTAINS("O'Malley",@cell), {Papers Range 3}, "1 - Published")
Answers
-
Yes, wildcards are badly needed. There's an enhancement request in Community that I encourage you to vote for.
That said, you can use CONTAINS often to accomplish what you need. Your formula would adjust to look like this:
=COUNTIFS({Papers Range 2}, CONTAINS("O'Malley",@cell), {Papers Range 3}, "1 - Published")
-
Thank you Brian!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!