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

joshuav81761
ββ
=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)))
Tags:
Comments
-
I'm not sure I follow. What exactly are you trying to accomplish? Can you provide more details?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!