Data from collapsed columns does not appear in mirror column

I have several use cases where I add a formula column to a board specifically to support a summary mirror column. I then collapse that column in the lower board as it is not relevant. The data is blank in my high level board unless I expand the source column in the low level board. Essentially I’m doing SUMIF() a lot of times using this pattern.