Counting Multi-Select Column value, based on another Column value

Options
wtcf
wtcf ✭✭
edited 07/05/22 in Formulas and Functions

Given the following Grid - I am trying to count all instances of 'Apple' in a Multi-Select Column ('Fruit'), but only when another column ('Market') has a value of 'Market A'


So in the above example, the answer would be 1, as whilst 'Market A' appears twice in the 'Market' column, 'Apple' only appears in the first instance ['Market A'].

Thank you in advance for any help!

Will

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!