Wildcard workaround

bs786

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!

Brian_Richardson

Yes, wildcards are badly needed. There's an enhancement request in Community that I encourage you to vote for.

https://community.smartsheet.com/discussion/102385/please-add-a-wildcard-function

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")

Brian_Richardson

Yes, wildcards are badly needed. There's an enhancement request in Community that I encourage you to vote for.

https://community.smartsheet.com/discussion/102385/please-add-a-wildcard-function

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")

bs786

Thank you Brian!