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.

Please add a Wildcard Function

Samuel Mueller

Mar 9, 2023

Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.

---

View Post

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.

Please add a Wildcard Function

Samuel Mueller

Mar 9, 2023

Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.

---

View Post

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!