Reference from Another Sheet Based on Criteria

Kimberlee Adam
Kimberlee Adam ✭✭✭
edited 10/03/23 in Formulas and Functions

There has got to be an easy solution... I can do this very easy with Reports but I'm trying to do it in a Sheet so I can integrate it into another application that wouldn't pull data from a Report.

All I want to do is reference a few columns from my main sheet based on a team members "Current Assigned Team".

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!