Hello Everyone, I would like to ask you if i...

(Sabry G) #1

Hello Everyone,

I would like to ask you if it would be possible to do the following: - if in COLUMN A I have a list of items, it can be banana, apple, coca cola, fanta is there any way where in COLUMN B authomatically record the type of the item (ie. fruit, drinks accordingly to the content cell in column A)? :slight_smile:

I am not sure if this can only be a dream but I would appreciate your support.

THANKS A LOT!

Sabry

(Praveen Seshadri (AppSheet)) #2

sure. give column B an App Formula. Here is a simple one: IF (

IN([Column A], {“banana”, “apple”}),

“Fruit” ,

“Drink” )

(Stefan Ottomanski) #3

@praveen very helpful. Have wanted to do this for a while. But what if column A has say, 100 different items and column B say 10 different categories. For

example fish Species (column A) and their families (column B).

Any suggested approach?

(Aleksi Alkio) #4

Then you would need to have separate table and you can read correct value from there. It would be like a dependent value.

(Stefan Ottomanski) #5

I suspected as much. Thanks again