Help with Collect / Match / Vlookup formula

Jed Rusyniak
Jed Rusyniak ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Working on a collection of sheets that I use between the different staffing agencies that service my operation.  My Sr. Ops manager publishes a sheet (with the green shaded cells in the attachments below) with the labor order (by agency) each day for up to a week at a time.  I am wanting to have the agency specific sheet (blue shaded cells in the attachments below) reference this master order sheet and look at the date and shift (am/pm) to return the ordered value by position code.  Initially thought maybe a vlookup, but that doesn't allow me to pull in different values for the same day depending on AM or PM shift.  I think a Collect formula is the way to go, just haven't been able to find a way to write this. 

Screen Shot 2019-08-06 at 2.12.35 PM.png

Screen Shot 2019-08-06 at 2.14.18 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!