# Help needed. How to calc number of Done/InProgress from a lookup array? **URL:** \ **Category:** Ask for Help\ **Created:** [July 7, 2023, 1:57am UTC](https://community.glideapps.com/t/help-needed-how-to-calc-number-of-done-inprogress-from-a-lookup-array/63606 "2023-07-07T01:57:00Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Darren\_Teoh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_teoh/32/61016_2.png) [@Darren\_Teoh](https://community.glideapps.com/u/Darren_Teoh)\ **Post date:** [July 7, 2023, 1:57am UTC](https://community.glideapps.com/t/help-needed-how-to-calc-number-of-done-inprogress-from-a-lookup-array/63606/1 "2023-07-07T01:57:00Z")
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: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b92390c6ce9280aeec325c3acd28069e867b11f.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 7, 2023, 2:09am UTC](https://community.glideapps.com/t/help-needed-how-to-calc-number-of-done-inprogress-from-a-lookup-array/63606/2 "2023-07-07T02:09:51Z")
You can use a [Query](https://www.glideapps.com/docs/reference/computed-columns/query-column) column for this. You’ll need a separate column for each status, and then a rollup for each one. ---
**Author:** ![Darren\_Teoh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_teoh/32/61016_2.png) [@Darren\_Teoh](https://community.glideapps.com/u/Darren_Teoh)\ **Post date:** [July 7, 2023, 3:54am UTC](https://community.glideapps.com/t/help-needed-how-to-calc-number-of-done-inprogress-from-a-lookup-array/63606/3 "2023-07-07T03:54:10Z")
Great Idea, it works not. Thanks Darren. 😃 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0668340fb7b6a58544f8dcac9ba59c57e49b37e.png) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 8, 2023, 3:54am UTC](https://community.glideapps.com/t/help-needed-how-to-calc-number-of-done-inprogress-from-a-lookup-array/63606/4 "2023-07-08T03:54:52Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.