Index / Collect /Match when there are duplicate rows

ralter
ralter ✭✭✭
in Formulas and Functions

I'm trying to return the first "yes" on Support Column if School District matches SD@row

image.png

pulling from this reference sheet:

image.png
· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole Community Champion
    edited 06/08/24

    @ralter

    =Index(Collect({Recruiter Support},{Recruiter Support},"Yes",{School District},SD@row),1)

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!