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.