use single select field values in input select

[lilialawh]

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

[Justin_Barrett · Accepted solution]

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.

[lilialawh]

Hello @Justin_Barrett,
Thank you for your reply.
It looks a good way for my question.
Thank you.

David
Best Regards