I like the function of the Sheet Summary but what I am curious on is how would one link a cell to one of those Values. Also how do we see the historic values for these fields?
1. Do you want to link in the same sheet or from another sheet?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
2. Unfortunately, it's not possible at the moment to see any cell history, but it's an excellent idea! (it might be possible in the Activity Log)
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
What I am really going for is to do my counts in the Status Summary and then use something like that in a Dashboard as either a Metric or a chart. What I am doing instead is from my main sheet what I have done is created another sheet for Metric and then doing the Sums or Counts in that grouping them by what I want. I can then use the data as either a Metric value or a Chart Value in a dashboard.
At the end of the day I am working to create a template set that has a folder structure for sheets, reports, dashboards and project plans to use for our team. I know of Control Center but I think the cost is not something management is okay with.
Depending on your specific needs and use case, it could be possible to keep everything in the summary section.
I am trying to achieve something similar to Michael. I've read most of the help guides and forums, but there is no guidance on how to reference a summary field from a different sheet.
Scenario: I have 20 project plans (created from a template), with each project plan containing summary fields (e.g. "Not Started Count", "In Progress Count", etc.)
Objective: trying to create a portfolio level dashboard where I simply sum-up all statuses (not started, in progress, complete) across all the 20 sheets, then present it as a single figure. Also I am trying to do so to take advantage of the summary fields within each sheet without having to re-type the same countif functions which is already set in the summary fields. I know both approaches will still require an aggregate data sheet.
Is this possible?
Or do I have to bite the bullet and replicate the countif function into an expression that will go over many lines. Just frustrating I am keen to use Summary Fields vs having totals embedded directly in a sheet, but no point if I can't reference them outside of its own sheet.
Unfortunately, it will not work with Sheet Summary because at the moment it's not possible to link Sheet Summary information outside of the sheet it's in, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
There are a couple of workarounds, and the best depends on your specific needs and process.
Would any of those options work/help? Which one do you prefer?
Be safe and have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
I was following the dialog but really didn't see what I was looking for. So if I could.
Can one link the value of a sheet summary field to another sheet field? In my case I am looking to link it back to another sheet. The link cell to another sheet feature does not allow me to choose a sheet summary field.
Sorry for the trouble. I did go back and find my answer!
Glad you got it working!
©2022. All Rights Reserved Smartsheet Inc.