I need to use CONTAINS to search in Table A a column value and compare it to a column value in Table B.
Is this possible?
I have this and it obviously is not working:
Contains([Ticket_Action], “On Rent”,
CONTAINS(Rental Tickets([Item_List], [_ThisRow].[Inventory_Item_ID]= [Inventory_Item_ID]))))