Blueprint SheetSummary Formulas

In the Blueprint project plan, there are Sheet Summary formulas, providing the 'Category' & 'Initiative' from the Project Metadata sheet. See below:

=({Project Metadata | Category})

=({Project Metadata | Initiative})

I need to add a new SheetSummary formula in the blueprint project plan to pull in the 'Workstream' from the Project Metasheet. The formula below is not working:

=({Project Metadata | Workstream})

Any advice?

Find more posts tagged with

Formulas

Sheet Summary

Control Center

blueprint

Accepted answers

All comments

Paul Newcome

What do you mean when you say it isn't working? Are you getting an error or an unexpected output?

J Mosher

Output: #INVALID REF

Expected Output: PLACEHOLDER

Paul Newcome

That means you have not followed the proper steps for creating a cross sheet reference.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

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.