What formula do I use to count a specific text when multiple text values are in a cell?


I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using keeps giving me zero. What am I missing? Any help you can provide is greatly appreciated!! 😊

=COUNTIFS({ANC F&E Pre-OR Issue Entry & Tracking 2 Range 1}, AND(CONTAINS("WOA", {ANC F&E Pre-OR Issue Entry & Tracking 2 Range 1})))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!