How to make this expression correct?

AppSheet AppSheet Q&A
1

MY EXPRESSION IS

IF((IN([_THISROW].[order],Tickets[Order])),

LOOKUP([_THISROW].[Order],“Tickets”,“Order”,“Customer”),

ANY(SELECT(Customers[Name],AND([_THISROW].[Customer Id Orders]=[B2A ID],NOT(CONTAINS([Name],@))))))

ERROR SHOWS

IF function is used incorrectly:the second input (if-result) and third input(else-result) should have the same type..HOW TO RECTIFY THE ERROR

2

Since the error is talking about column type of the results, you may want to verify if the column [Customer] in the “Tickets” table and the column [Name] in the table “Customers” are of same column type.

2 Likes