When mirroring a subitem column containing Text, the mirror column just spits out a comma-separated list of every single value, including duplicates. It would be nice if it could behave like a Dropdown or Tag mirror column and just list unique values. It could be added to the “Customize Mirror Column” options, similar to how we have options for Date and Number mirror columns.
We use a column to track the city of job sites. Some projects can have multiple sites in the same city. It’s silly to have a mirror column that says, for example, “New York, New York, New York, New York, New York, Las Vegas, Las Vegas” when it could just list each city once: “New York, Las Vegas”
I tried to make a Formula column to fix this, but it doesn’t seem possible with Monday’s formula selection.