Create master inventory, then filter the master list on different boards

Hello,

We’ve been using Monday.com for nearly a year now. We’re looking to move some of our other processes across to it.

We run a fleet of vans - each with different equipment.

What I’d like to do is create one board with a list of all the equipment on it. We do this in Google Sheets at the moment. Each van has a column to say which equipment it should have on it.

Then I’d like a separate board per van that looks to the list equipment and filters to only show the equipment that is required for that van.

So Van 1 may need Items 1, 2, 4 and 5. Van 2 may need Items 2, 3 and 4.

I’ve played around for a few hours and can’t figure out a way to do this.

Does anyone have any bright ideas? Thanks for your help.