I looked through several threads that were also trying to find COUNTIF workarounds, but none really matched the use case I have, so I’m hoping to find some help.
We use Airtable to manage a large editorial team and content calendar. We have our main editorial table with our content roadmap and weekly assignments. My colleague who manages our freelance writer network has created a separate table with information about all of our freelancers including their names, contact info, assignment capacity, area of expertise, etc.
She is wanting to find a way to count all active assignments assigned to a particular freelancer and pull that number from our main editorial table into her freelancer table. Is this possible?
I can easily find the assignment count of each freelancer within our main editorial board, but can’t figure out a way to get that count to show up on the other table. Right now she is manually counting and putting that number in there as plain text. I’m attaching screenshots for better visualization.