Partial text search


Hi All!

I'm looking for a formula that does a partial text search, counting shift codes containing "AS." The column will appear as below, but I want the formula to only consider the AS.

It will need to be added to the formula below,

=COUNTIFS({USER ID}, [Team/ Colleague ID's]@row, {Period2}, [Period ]@row, {year2}, Year@row, {Assem%}, >=0.95, {STD}, >=0.84)

Is this possible? Any suggestions?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!