hi, I would like to insert a rule with differ...

(Mark Pathfinder) #1

hi, I would like to insert a rule with differente condition as google sheet: if(a1=“white”,b2;if(a1=“red”,b3;if(a1=“yellow”;b4;b5)…how can I do in AppSheet? actually I’ve insert IF but just with 1 condition

(Levent KULAÇOĞLU) #2

@Mark_Pathfinder can you elaborate your question? Where do you want to create this IF expression in AppSheet? For what purpose?

(Mark Pathfinder) #3

I would create a multiple condition; actually there is just one condition: =if([Assegnato a] = “Me Stesso”, [Chiamata effettuata da],[Ragione Sociale].[Agente])

in excel i would have inserted more if

Translate

(Levent KULAÇOĞLU) #4

@Mark_Pathfinder

You can use nested IF or IFS expression

(Mark Pathfinder) #5

it works. Tx