Categorizing Products according to flavours

Topic Labels: Formulas
531 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Basically would like to do

Lookup, {Products ordered}
Double Scoop (Chocolate + Vanilla), Single Scoop (Chocolate), Triple Scoop (Chocolate, Vanilla, Mint)

Formula field {Flavour categorizing}
Chocolate, Vanilla, Chocolate, Chocolate, Vanilla, Mint

The issue is that, the Lookup field can be different products at different arrangements, but would love to have the formula field to be able to SEARCH a certain product and state its flavour of choice. like the example above!

Any help will be much appreciated!

0 Replies 0