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
Best answer by Justin_Barrett
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.
+21Welcome 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.