Blueprint SheetSummary Formulas

J Mosher

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?

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

.