Help

Count single select quantity from different table

Solved
Jump to Solution
2223 2
cancel
Showing results for 
Search instead for 
Did you mean: 
lilialawh
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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.

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

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