Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Count single select quantity from different table

Solved
Jump to Solution
468 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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