Formula fields with Mirror Columns I'm not permitted to see

Hi Guys, I got a question here.
So I have a board for our Controlling that is a collection of BudgetIDs each of our three teams can link to. So that we can say some activity with x€ spend is associated to BudgetID 1.
We use the mirror column to mirror those spends back to the Controlling board.

Now we got three teams whose spends we want to track here, and each one of them can only see their own board. In the Controlling board however they should be able to see the sum of all boards and how much is left of that budget.

Now as you can see from that Screenshot everything looks fine for me as an admin as I’m able to see all boards. But if you work in one of those teams they just receive an error message in all formula columns (orange) as they can’t see all those linked columns.

Is there any way to have the formula column always show the correct value of all fields even if you’re not permitted to see all of them?

A dashboard wouldn’t work in this case as we got a lot of (50+) different BudgetIDs here that should be editable very easily. Therefore the linked column would work perfectly if there wouldn’t be this limitation with the fields you’re not permitted to see.

Hi Antal,

Jenna here for the team :wave:

In short, what you are looking to achieve is not possible at this time unless you give these teams access to all of the boards the mirrored information is coming from.

In order to view information from within The Mirror Column, you need to have access to the board that this information is coming from.

Any formulas that use data from a mirror column you cannot see means that you cannot view the information within the formula column.

I hope this helps clarify!


Hi, @Antal - The workaround for this may be using the General Caster app for your formulas. It would need to be configured by a board owner, but then you can “cast” the result of the formula into a column that you would be able to view. We have several clients who have chosen General Caster to also hide the mechanics of the formula from other team members, while letting them see the result.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.