Hey guys,
hopefully someone who has experience with my issue would be able to help me with it.
Use case:
project management boards to track Income, Expenses, and Subcontractors payments.
this is how the boards are built:
Board - Projects:
item - project one
item - project two
--------------------------------------
Board - Subcontractors:
item - Plumber
subitem - project one | agreement cost: 2000$ | paid: ""
subitem - project two | agreement cost: 4000$ | paid: ""
item - Electrician
subitem1 - etc.
--------------------------------------
Board - Expenses:
item - project's name1 | linked project="project one"
subitem1 - Material | amount: 100$ | linked boards: subcontractors=
subitem2 - Plumber | amount: 200$ | linked boards: subcontractors="Plumber"
item - project two
subitem1 etc.
--------------------------------------
In short:
when entering in the Expenses subitems subitem2 - Plumber | amount: 200$ | linked boards: subcontractors='Plumber'
the amount 200$ should be added to the the Subcontractors Board and add the value 200$ in the “paid” column.
In length:
in the Expenses Board I’d like to distinguish between a regular expense such as material expenses and expenses that would go to subcontractors (The way that I’m doing it now, is by linking the row with the subcontractor via “connect board”) I hoped that this way I can keep track of what the agreement cost between me and the subcontractor was and how much I ended up paying them, unfortunately this is not to my liking.
How could I make a formula that can distinguish between a linked subitem from another board and calculate only the subitems that are each linked to a subcontractor in the current project (the project is linked to the parent item, the subitem is linking to the subcontractor).
The end goal is to add the amount entered in the Expenses board linked specifically its subcontractor to the subcontractor’s “paid” column so I can keep track the amount paid VS the agreement cost we had.
I hope I didn’t get too many of you confused.
thanks in advance
