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.
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 firstname.lastname@example.org if you have any questions.