Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Categorizing Products according to flavours

Topic Labels: Formulas
273 0
Showing results for 
Search instead for 
Did you mean: 

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