Formula Question


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!