Count String Occurrence in a Cell

Nazeer Sayyed
Nazeer Sayyed ✭✭
edited 03/25/21 in Formulas and Functions

Hi There,

I have below two columns in my sheet. Column [Status (Delivered)] has concatenated values (WIP and Delivered). In [Delivered Count] column, I need to show how many times 'Delivered' string occurred.

Please see below example.

image.png


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!