Reporting - Multiple data values in a call from multiple sheets

Hi Community:

I have a sheet that has a column with multiple text values in a one cell. I want to calculate how many times a text value is mentioned in a cell across multiple sheets. How do I do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!