Autotate using Mirrored/Formula Columns

Hi- I have a main board that is pulling from an API several different columns of data. This board is main source of data for several sub-boards. Right now, I am connecting this board to the sub-board via a mirrored column, and then so I can sum those columns, I am doing a formula column equal to the mirrored column. However, as you can imagine, I cannot do any automations off of the mirrored column or formula column. Any work arounds? I was trying some marketplace integrations, but can’t seem to find the right one. My ideal recipe would be: When mirrored column changes, update Column C with updated data (that is able to be triggered by automation). Hope this question makes sense.

Hi @EPMLIving,
This is now possible with VLOOKUP, which permits formula columns to be used in connecting formula type columns between boards.
This ensures that the automation features are preserved.
Here’s a step by step guide on how to accomplished this.

Send an email to if you have any questions.