Formula Question

Anthony D'Ambrosio

Hello Smartsheet Community!

I was wondering if someone could help me out with a Formula. I am trying to figure out total number of Art Shop requests by Assigned To. I know how to write a formula to count individuals, but it's not counting individuals when you have multiple people assigned to an Art Shop. For example, if I use the formula =COUNTIF([Assigned To]:[Assigned To], "Brian Elliott") it will only return a count of 1. However, if you look at the screen shot, Brian is assigned to a project on line 5 and 7. Any help would be greatly appreciated.

Paul Newcome

Try incorporating a HAS function.

=COUNTIF([Assigned To]:[Assigned To], HAS(@cell, "Brian Elliott"))

Paul Newcome

Try incorporating a HAS function.

=COUNTIF([Assigned To]:[Assigned To], HAS(@cell, "Brian Elliott"))