How to sum invoices on one board into the relevant project on a second board

Let me start by letting you know that I am very new to monday.com… so any advice is good advice!

I have 2 boards, one which has each of our remodels (with a store number in one of the columns) and one where we are inputting our invoices for those projects (where we are also entering the store number). I need the board with our remodels to reflect the sum of all invoices that have the same store number as the remodelled store.

I’ve searched dozens of articles in the discussions, but cannot find any help. Mind you this could also be because I’m not asking in the right terminology. Any help is appreciated… even if it’s to tell me I’m approaching the problem from the wrong direction!

You’ll want to add a connected column to either of the boards and then ‘connect it’ to other (making sure you do a 2 way connection). Then you’ll use a mirror column to pull in the invoice column.