Linking 2 Sheets

I have 2 Sheets the First Sheet shows All accounts (which is unique) the 2nd sheet may or may not contain all accounts but each account has multiple values (rows). How can I add the multiple values into the first sheet?

Basically the 1st sheet will have to expand rows.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!