Help Searching Mutiple Job#


I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project.

I want to be able to do it for multiple Job Number that are in the Job # column separeted by a " - "

In this example will be Job 123, Job 124 and Job 125.

Is there any way to do this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!