Newbie: INDEX and cross-sheet reference.


Hi...and thank you for any help you can offer.

It is quite a transition from Excel and Google Sheets to SmartSheet, but I know it's going to be worth it!

I am trying to make a master sheet and then use different columns of data in other sheets.

I know this works for 1 row:

=INDEX({Symbol}, 1)

I cannot figure out how to change the formula to populate the entire column ("Convert to Column Formula") of 366 symbols from the master list.

I tried @row from this page with no success:

I realize this is probably a super basic question, and I am grateful for the help!



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!