Wildcard workaround



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!