Who is familiar enough with Summary feature in sheets, do I need it if I reports built off the same sheet?
is there an advantage of one over the other?
Thanks in advance
For me, Summary - is useful if you want to keep things conceptually separate. So, on your sheet you may have calculations and metrics - but you may want to do some other calculations or store other data that doesn't make sense to be on the sheet itself. For example, you might have a Project Description or a project status flag. Those things are 'about' the thing rather than part of the thing itself (if that makes sense).
Obviously, there's more than one way to do summary data.
2 and 3 are particularly relevant if you use something like 'Control Centre'.
So in short, it depends n what you are trying to achieve and the context of what you are trying to do. But a general rule is that if what you are doing works for you and your team, then it's fine. But if the sheet is getting messy and is a mix of data and summary data and is getting hard to use - then summary (in one of its forms will be useful).
I use summary a lot as I like to keep my concepts separate and keep the sheet as simple as possible. You can reference summary data in your sheet as well.
There's much more info on Summary here: https://help.smartsheet.com/learning-track/level-2-intermediate-users/sheet-summary
Which may help.
I have a sheet that tracks employees certifications. I'd like to setup a single automation that runs weekly to alert the employee when the expiration date is within 180, 90, 60 and 30 days away. I'd prefer that the 180 day alert only be sent monthly until the 90 day date is hit, then weekly. I'd like the message sent to…
Hi there, I want to use the trigger and alert to notify someone in the next row when the task above is complete. E.g., if the Status column is changed to Complete in row 3, I want an alert to be sent to the contact in the Assigned To column in row 4. Is that possible? Megan
I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified. My need is to be able to collect the max…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.