Skip to main content

Hello all,



Now, I want to count a single select quantity from a different table


Table 1 like this




Table 2 like this




And I want to count Table 1’s status quantity


I want the result in table 2 show


todo 4


in progress 2


done 2



Does anyone know how to do that?



Thank you all.


David

Welcome to the community, @lilialawh! :grinning_face_with_big_eyes: Turn the single select field into a link to your other table. You can then use either a rollup field or a count field in the second table to count the number of incoming links, which will provide the tally of each selected status.

Welcome to the community, @lilialawh! :grinning_face_with_big_eyes: Turn the single select field into a link to your other table. You can then use either a rollup field or a count field in the second table to count the number of incoming links, which will provide the tally of each selected status.


Hello @Justin_Barrett,


Thank you for your reply.


It looks a good way for my question.


Thank you.



David


Best Regards

Reply


Terms & Conditions