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.
After a form is shared with someone else, is it possible that they add a value in another cell?
Hello, I have notice anytime I try to reference a column in a formula it doesn't automatically recognizes the name and then I always get the unparseable error. For example in below I want Smartsheet to calculate all the item listed as test under the column implementation Manger. =COUNT(Implementaiton Manager:Implementation…
Is there a way to create a filter to only show let's say cells highlighted in yellow?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.