Formula to return more than one value - Please help!!!!!

Options

=INDEX([Job Name]1:[Job Name]15, SMALL(IF([Job Number]22=[Job Number]1:[Job Number]15, ROW([Job Number]1:[Job Number]15)-ROW([Job Number]1)+1), ROW(1:1)))

Capture.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!