Help needed. How to calc number of Done/InProgress from a lookup array?

2 tables with Work Progress Status in Stage 1,2,3. Another table lookup all work progress per stage and trying to calculate number of work progress status.
Please refer to image below:

You can use a Query column for this. You’ll need a separate column for each status, and then a rollup for each one.

1 Like

Great Idea, it works not. Thanks Darren. :smiley:

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.