Formula help for finding a user in a list of users imported from a Jira custom field

[Hannah_Pearce]

I am working with a Jira pack import where we have a custom field ‘contributors’ where multiple users can be placed in that field.
I am trying to create a ‘count’ of a particular user in the adjacent column. I’ve tried a few different formulas but I’m continuously getting a ‘0’ response. I’d greatly appreciate any guidance

[Christiaan_Huizer]

hi @Hannah_Pearce ,
First, welcome to the community and second the best way to move forward in general is sharing a sample doc. That said, I wrote a short code snippet that maybe could help you.

thisRow.Contributors.ListCombine().Filter(currentvalue.ContainsText("Mattias Johansson")).Count()

cheers, christiaan

[Hannah_Pearce]

Thanks so much that was perfect!

I’m fairly new to coda and I wasn’t sure about embedding the sample as it has Jira data in it - I wasn’t sure if that would have been viewable.