Index collect from second sheet based on two criteria

After developing the below function, I later realized in addition to Participant@row, it needs a second criteria but I'm unsure how to update. The two criteria's are to match Participant@row with Program Year@row in both sheets before returning Milestones Submitted.

Thanks in advance for your help.

=INDEX(COLLECT({Milestones Submitted Tracker}, {Milestone Tracker 2}, Participant@row, {SEG Participant Tracker ADMIN Range 3}, Milestones@row), 1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!