Is it possible to reference a cell or summary field in a column formula?

At the top of our templates we have a Summary section where project (deliverable) details and key people are specified. I am wanting to reference the 'Deliverable Sponsor' cell within a hidden column on the sheet so we can create reports pulling through all row data across all deliverables that belong to that Sponsor.

From what I have found so far I don't think it is possible to reference this cell in a column formula so I have tried creating a Summary Field that references the cell.

I have created the Summary Field 'Sponsor', but when I try to reference this in the column I have created with ={Sponsor}, it is showing as #INVALID REF.

I don't know why this is happening. I copy and pasted the name so I know it is written exactly the same. Any guidance?

Find more posts tagged with

Formulas

Sheet Summary

Cell Reference Limits

Accepted answers

VBAGuru

As a clarification, is the Summary field 'Sponsor' part of the sheet summary? If so, try [Sponsor]# using the brackets [ and ], not { and }.

All comments

VBAGuru

As a clarification, is the Summary field 'Sponsor' part of the sheet summary? If so, try [Sponsor]# using the brackets [ and ], not { and }.

EmilyScerriDavis

Yes it is in the sheet summary.

Thank you! I had tried square brackets first but didn't put the # at the end which explains why it wasn't working

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.