Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 09, 2024 01:57 PM
I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteered
I want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and if I filter for the specific month, will it still work?
Thank you!
Solved! Go to Solution.
Apr 10, 2024 03:26 AM
You can create a "Months" table, which will contain the list of months.
In the "Months" table, create a lookup field to the table where you keep track of volunteers. You can set up an automation to automatically link each time someone volunteers.
Then, you can simply create a Rollup field that will count the unique volunteers.
Example formula:
COUNTAll(ARRAYUNIQUE(values))
Result:
If you need more help feel free to schedule call with me.
Apr 11, 2024 09:18 AM
Hi,
For a quick look, you can choose unique
and group by month with 'Collapse all'
But if you want to use these numbers per month, you should follow link provided by @Ella
Apr 09, 2024 03:55 PM
If you create a linked record and a roll-up field then you could use the solution in this post (https://community.airtable.com/t5/show-tell/count-unique-values-in-rollup/m-p/113668#M1834) potentially.
Apr 10, 2024 03:26 AM
You can create a "Months" table, which will contain the list of months.
In the "Months" table, create a lookup field to the table where you keep track of volunteers. You can set up an automation to automatically link each time someone volunteers.
Then, you can simply create a Rollup field that will count the unique volunteers.
Example formula:
COUNTAll(ARRAYUNIQUE(values))
Result:
If you need more help feel free to schedule call with me.
Apr 11, 2024 09:18 AM
Hi,
For a quick look, you can choose unique
and group by month with 'Collapse all'
But if you want to use these numbers per month, you should follow link provided by @Ella
Apr 12, 2024 06:37 AM
Thank you! That is a simple way to get what I need - which works for me!