I have a map for a table called “Workorders”.
Each workorder has three separate trips by three separate crews that must be made. For each of those trips types, I have a table for each. Locate Ticket, Bury Ticket and Aerial Ticket. Each table has “a part of?” checked and is working fine.
In the Locate Ticket table, there is a Column type Enum called Status. It’s options are Pending, Complete, Hold.
I’m trying to format the pins on the Workorders Map based on the Status column of the Locate Ticket table.
“Complete”=(Locate Ticket[Ticket Status])
I am getting and error. Cannot compare Text with List in (“Complete” = Locate Ticket[Ticket Status])
I’ve been trying to figure this out for about a week pouring over the forums. I’ve been trying to find another way to format the formula to no avail.