Formula for cells with multiple assignees

Paula Cosentino · 06/14/19

Hello, I have a projects list that allows multiple people to be assigned. What is a formula I can use that will count someone's name when a cell has their name plus other(s)? Thank you in advance.

Formula will be used as a basis for a dashboard

Andrée Starå · 06/14/19

Hi,

Try something like this.

=FIND("Name"; [Assigned To]@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Have a fantastic weekend!

Did it work?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Formula for cells with multiple assignees

Comments

Help Article Resources

Categories