Using {mirrorName} in a formula copies the aggregate cell data. Can I grab only pieces of it?
For example if a mirror column aggregates 3 sources of data, say item quantities (Red-12, Green-6, Blue-19), can a formula identify only the red source? For example {mirrorName#Red} and show 12 in the formula column?