Max value with min collect

ateleoh
ateleoh ✭✭
edited 12/09/19 in Formulas and Functions

I know this is need of a combination of things, but I cant figure it out unless I use a range of cells.  I would prefer to search the collective column to perform the task.

I want to return the name of the Visit Provider who has the greatest number of SumCompSched for each Phase & Clinic.  

 

I appreciate the help in advance.

Capture.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!