Count single select quantity from different table

Hello all,

Now, I want to count a single select quantity from a different table
Table 1 like this
image

Table 2 like this
image

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! :smiley: 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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.