Auto Reference one sheet to another

Coach Barnett

Hello all!

I am trying to create a sheet that will auto update based off it's master sheet. I know that I can Link cell in other sheets but it only allows me to do 50 cells. Is there a way to link more than 50 cells or the entire sheet?

Christina09

Hi @Coach Barnett,

Yes, you can add a helper column with a unique ID to have it index/match the master sheet.

Here's a link for reference: https://community.smartsheet.com/discussion/32686/auto-filling-a-cell-based-on-the-entry-in-another-cell