Is there a formula where I can identify first item alphabetically in a list?

For example, if I have a list of names and projects, I would like to identify the first name alphabetically for each project. In the image attached, Alex and Jane should be the first people alphabetically for their projects. Is there a formula that could evaluate a text range and determine which value is first alphabetically?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!