MIN(COLLECT) with multiple criteria

I need to collect the earliest date on a sheet based on a company but also based on whether an employee made the contact or a consultant.

I started with: =MIN(COLLECT({Date}, {Company}, [Company]@row)) - and this worked overall, but not sure how to add in the second parameter.

This is and example of my source sheet:

And on my formula sheet I have separate columns for EE/Consultant

How do I take my original formula so that it returns a date only if an employee made the contact? I think I would =MIN(COLLECT({Date}, {Company}, [Company]@row, {Employee}, ___________)) but I'm not sure and everything I'm trying isn't working.

Would love some thoughts.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!