Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way.
The first four columns in my Master Sheet would need to be on every sheet, they hold critical status, dates, size, name of site. These factors are used in all calculations.
So if I make one sheet for summary of sizes.
One sheet for hours
One sheet for dates
Don't I now have the risk that a date is updated on the master sheet or a size? I must have cell linking to ensure they stay the same between sheets right?
So now even if I use Zapier to create a new row in the other sheets once a row is added to the Master sheet now I have to manually go in and create links for those key cells. Also my concern, aren't links one way? So if a person is working in the dates sheet and knows that it has changed, they enter it, but if link is from Master to Dates Sheet it won't update the master correct?
Seems like I have to now have manual step on multiple sheets to have data integrity to work around poor performance response. Is there another way? Do Links Autofill like a formula with the next row down each time a row is added?