Multi Page Formula dragging:

robert.castleberry53921

I am working with multiple data sheets where my formula draws information from the same cell in 4 sheets, i.e. =SUM({pg1 cell1}, {pg2 cell1}). The formula works correctly, but when I try to tag and drag or C/P the formula into the rest of the cells in the column, it simple duplicates the same original cells, rather than adapting the data for the new cells.

So if I drag the cell to copy the formula to cell 2, it still reads =SUM({pg1 cell1}, {pg2 cell1}) rather than =SUM({pg1 cell1}, {pg2 cell2}).

As the core Sheet is a summary of a rows from other sheets, I can't write them all myself, so it is a deal breaker if I can't make this work in Smarsheet.

Thanks for any assistance.

David Tutwiler

Unfortunately I don't think this will work like you want it to. When you're referring to other sheets you are making references that are saved in the background. There is no inherent way to offset those references, but instead you would need to make a specific reference every time.

David Tutwiler

Unfortunately I don't think this will work like you want it to. When you're referring to other sheets you are making references that are saved in the background. There is no inherent way to offset those references, but instead you would need to make a specific reference every time.

robert.castleberry53921

Thanks for the reply David.

Just spoiled from doing this internally in Excel for so long. Sounds like tome for a workaround perhaps just pulling the data into hidden columns and going from there.

Thanks again,

David Tutwiler

Smartsheet does take a bit of a different approach in thinking about certain solutions, this coming from a previous Excel junky. But trust me, stick with it. It's worth it in the long run.

Good luck!