Cannot compare List with Number in ([Assigned Operators] = [Emp Id].[Emp Id]) - Any alternative solutions for this please??
Dear Experts, We have developed an application where
we can change the equipment status “Working”, “Available”, “Standby” etc., When the status is “Working”, we may assign more than one operator for that particular equipment.
I have Equipment Status Table, where we can add an equipment first time, then just change the status.
I have Operator Directory, where I want to connect the equipment status as Operator Status. So that i can bring both Equipment and Operator Status. The problem is If i create a virtual column “Status” in operator table by using this below formula… =LOOKUP([_THISROW].[Emp Id], Equipment Status, Assigned Operators, Status) … i get below error message.
Cannot compare List with Number in ([Assigned Operators] = [Emp Id].[Emp Id]). How do i take the assigned operators to operator Directory.
Please help us out from this big obstacle as we almost there to complete this project. Our Management is welcomed this Concept.