I have a column Item Name which contains ref to another table with all product details and I want to have a if condition for this i.e. If curtain track is bent then in Item name drop down only product with name “Forest” should come else rest of all the products can come.
I have written a expression as below but getting the below error.
Expression : If([Is the Curtain Track bent] = yes,LOOKUP([Item Name]=Forest,Curtain Track,Item Name,Item Name),LOOKUP([Item Name],Curtain Track,Item Name,Item Name))
Error : The expression is valid but its result type ‘Ref’ is not one of the expected types: Yes/No, List
Any idea on how can I resolve this issue?