Linking Sheets

kandacecole

Due to the 200 column limit in a sheet, I have had to split my data into multiple sheets, using the project name as the Primary Column for each sheet. I know how to links cells and use IF formula to pull the Project Name column data, but I cannot for the life of me figure out how to automate it, where if I add a project name to the Master sheet, it pulls the project name through to all of the destination sheets by itself, without me having to do anything.

Please help!!!

Andrée Starå

Hi,

Do you want to automate, so the project name appears on all sheets in a cell or a column title?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Alejandra

Hello,

This level of automation can be accomplished with the DataMesh premium app.

If you're interested, more information on DataMesh can be found in our help article: https://help.smartsheet.com/articles/2476796-get-started-smartsheet-data-mesh