Workaround for Sheet Reference Limit?


Hi everyone,

On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel actions organized in rows based on the 50 items. Our goal is to have this sheet auto-populate from changes in the project plan to automate the weekly process of validating this tracker before sharing the updates with our clients. For this to work we would need around 950 references by the end of the project.

Any way we could manage this in smartsheet?




  • Devin Lee
    Devin Lee ✭✭✭✭✭

    Pretty sure we need more information and clarification here. If you just want to know if it's possible the answer is yes. If you want someone to help you make it work we need more information. My first thought is use three sheets. One for copy/paste the excel data into, the other sheet you mentioned and than a third sheet that pulls data from both the Excel and the Smartsheet to do the updating.