Sheet References from multiple sheets


Struggling with cross referencing multiple sheets.

Sheet 1 - is auto-filled by a form from users in multiple areas.

Sheet 2 - contains the standards for one area.

Sheet 3 - needs to pull

  • from sheet 1 (Task) and (Time) respective to area M1 &
  • from sheet 2 The (Standard Time) relevant to Stanard Task

I have been attempting to use an Index Match combination but have been unsuccessful.

In help greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!