I have an individual systems list, on which are a column of divisions (Parks) and a column of 'compliant' systems.
I also have a program-wide list of compliant systems.
Is there a way to create, on the program-wide list, a column that auto-populates the 'number' of compliant systems from the individual list of systems - based on the Park they are locate.
Example: individual list may contain 10 line items of systems at 'ACME' park; 7 of those systems are compliant, 3 are not compliant.
The calculated column of the program-wide list, or the workflow, would need to automatically place a '7' in the program-wide list 'Compliant' column.