Absolute Reference Cells

Is there a way to create an absolute reference cell that stays relative to a series of copied cells?

I have a sheet that uses a series of formulas to summarize expenses pulled from other sheets and allows me to use this data in tracking a project's budget balance.

Each line and column that reports dollars spent (except for the totals) reference the same cell. To prevent issues with dragging formulas around I made that cell an absolute reference in the formula, i.e. =SUMIFS({TotalWages}, {Month}, TackCode@row, {ProjectName}, $ProjectCode$2215)

My issue is when I copy this block of cells into a different section of the sheet for a different project. The copied cells reference the original cell ($ProjectCode$2215). To have it accurately calculate the data I have to manually update the row number in the formulas. Is there a way to maintain the relative reference while copying? My hope is that I can copy and paste to the new block and the reference would update to new reference cell.

Is this possible?

Answers

  • Hi @Ryan Williams

    No, it currently isn't possible to copy/paste a formula like this and have the absolute reference be relative to the position of the new cells; it will stay with the originally identified row or column.

    You would need to manually adjust the row number and then drag-fill the new rows as you've been doing. Please let the Product team know about your feature request by filling in this form, here!

    Thanks,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

  • Thanks for responding! I didn't think it was, but was hoping I just didn't know how to do it. I'll submit a feature request.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!