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?

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

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

Ryan Williams

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.