Sheet References from multiple sheets

Options

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.



Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!