There is a bit of a cheat code to it…
Let’s say we have three boards (A,B, and C).
Boards A & B are connected.
Boards B & C are connected.
Board B rolls up/mirrors information from board A.
Board C then mirrors the mirror column on board B of board A’s column.
Board C wants to use Board A mirrors in a formula.
This is where the error occurs!!!
Solution, make this change instead:
Boards A & B are connected.
Boards B & C are connected.
Board B rolls up/mirrors information from board A.
Board B has a formula column displaying the information of the mirror from Board A.
Board C then mirrors the formula column on board B of board A’s column.
Board C uses the mirrored formula column in a formula without issue!