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

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'


smartsheet_capture.PNG

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!