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