Example
I have created a board (to manage vendor invoices) and every item under that board I have a unique key (this key will be used for vendor payment against project in Main board)
Now suppose vendor have raised invoices against project which are added against project :
Ex : vendor 1 raised 2000 INR against New_LMS project under Field (Invoice 1) and Vendor 2 raised 5000 INR under same project.
Now in budget under ITEMs Board :
Pending amount must be Total amount – (Vendor 1 + Vendor 2 invoices ) = 418,000 – (2000+5000) = 411,000 INR as a result (This is output what is required from Budget perspective) .
Please let me know if this is understandable or happy to show via webex or zoom .
Is it currently possible to reference a field (specifically in my case, a number) from another board an use that in a calculation? If so, what is the syntax?
Great suggestion. I have at least 3 boards (Inventory related) that have lots of number columns and would love to be able formulate data from a column from another board into another board!