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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!