Max value with min collect

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!