Sheet Summary
Has anyone started using this new feature? It's unclear to me what it is this summarizes. How are other using this, any examples?
Comments
-
Hi Eddie,
Yes.
Here are two examples.
- Collect sheet/project KPI's.
- Add project information like Project Name, Goals, Stakeholder, Budget, Expenses, Overall status, Project Manager, Dates, and more.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Any thoughts on how to do the KPIs you mentioned? this seems to be a tool with a lot of potential, but like the OP I'm a bit non-plussed as to how to go about putting it all together
Garmon
-
Hi Garmon,
You'd add the fields in the Sheet Summary as needed for your KPI's.
Then you can input formulas and reference/calculate data from the sheet or other fields in the Summary Sheet section.
Examples.
- Count all tasks, count all overdue tasks.
- Input total budget and show the current value.
- Add the people involved in a project.
- Show overall RYG status
- Add a start date and end date for the project
- Add progress pictures
- Link to collateral material
- Link to other sheets, dashboards, and reports
Hope that helps!
Let me know if you have questions!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi everyone—
I wanted to pass this learning track along to you all to get up to speed on sheet summary. Getting toward the tail end of that learning track, there's content on sheet summary formulas to aggregate data into a portfolio, summary reports, and other tips: https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary
-
Thanks, Shaine!
I also see now that Sheet Summary Reports are official.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
You can also reference the Summary fields in the sheet itself. If your summary field is titled "Example", and you wanted a box on the sheet itself to be checked if that field is populated, you would enter the field name followed by a #, and it would look something like this...
=IF(NOT(ISBLANK(Example#)), 1)
.
To reference the sheet in formulas within a Summary field, you would write it out exactly as you would if the formula was in a cell on the sheet itself.
.
You can also use cross sheet references in formulas within a Summary field, but you cannot access the Summary fields through cross sheet references.
-
Paul,
can you share how can I reference another sheet summary sheet?
Thanks!
Eli
-
Hi Eli,
Unfortunately, it's not possible at the moment to reference another Sheet Summary, but it's a great idea! (You can reference another sheet through Cross-sheet reference but not the Sheet Summary)
Please submit an Enhancement Request when you have a moment.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
What would be REALLY nice is if we could reference reports in cross sheet references, but I digress... Haha
-
How is Sheet Summary different from using the Report function?
Thanks.
-
Reports and Sheet Summaries are vastly different.
Here is some documentation on reports: https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports
And sheet summaries: https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary
-
New fields in a sheet summary can include formulas. So in that side-panel you could mission-critical things like COUNTIFS, SUMIFS, etc. It provides you a space that isn't in the sheet itself to store some of the sheet-specific data. As the summary data isn't readable by cross-sheet references this would be ideal for self-contained sheets that aren't being calculated elsewhere. If you are working within a fiscal year, or with data that is ongoing in a single sheet. You could summarize your data there.
-
I am working on a "sort of but not quite" Summary Report that will pull data semi-efficiently from Sheet Summaries into a report type format that can then be accessed via cross sheet references for metrics.
Basically I have a template that gets used many times. Each of these templates has a Charter built in that data is cell linked from into a Rollup Sheet. The issue here is that the Charter has the data vertically in a column, but the Rollup has that same data from every charter listed out a cross a row.
This becomes tedious because the ranges are not the same shape. This means that each cell from the Charter has to be linked one at a time across a row in the Rollup.
The workaround I created for this particular issue was to use the helper columns I already had in place for various automations and essentially cell link the data from the Charter into a horizontal layout.
We could then select the appropriate number of columns across a row in the Rollup, access the option to link from another sheet, then select the horizontal layout of the Charter to allow us to link them all at one time.
.
I took this same concept and applied it to the Sheet Summary.
The Summary looks like this...
[Field 1]
[Field 2]
[Field 3]
.
But then I have a row hidden from immediate view that looks like this...
=[Field 1]# =[Field 2]# =[Field 3]
.
I can quickly link the horizontal to the Rollup with built in filters which essentially works as a report that can also be accessed by cross sheet references for metrics reporting.
.
This has allowed me to essentially combine my Project Charter and my Project Plan into one sheet, hide the Charter by using the Sheet Summary for it, and run metrics on Workspace wide reporting by not using actual reports.
-
Are there any examples of Summary Sheets being used other than the help videos? The video is just too short to glean useful application information.
Thanks!
-
Hi Joseph,
Here's an excellent video from a webinar last week all about Sheet Summary and I've also added a few screenshots from it.
https://help.smartsheet.com/learning-track/best-practice-webinars/report-key-metrics-sheet-summary
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives