Auto Group data
All information on this form comes from Forms. I want the data to all be grouped together for the same PC (Profit Center) as it comes in without having to hit sort button each time. How do we do that?
Example as data comes in i want all data from a certain PC to be grouped together so I can see all data inputted from that PC as it comes in.
Answers
-
Unfortunately there is no way natively in Smartsheet for this to happen, however @SSFeatures has a great browser extension that does this.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
So there is not an Auto Sort or anything that can be put in place as data comes in? Right now all info is added in chronological order and then user has to select sort by PC to make it sort. Is there not a way to have it added and auto sorted by a category?
-
Thanks for the notification @Michelle Choate 2!
Hi @david.saunders, I created a browser extension to solve this problem:
It adds a "Sort Automatically" checkbox that you can click, and it will automatically sort the rows whenever the data changes.
The extension also has some other features that you might find useful!
Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds more features into SmartSheet.
- Report PDF generator that supports grouped and summarized reports
- Automatic sorting, sorting with filters, saving sort settings
- Hiding and unhiding columns, and spell checking
-
That was perfect. Can you help me brainstorm a way to maybe add a space in between those different catagories so they dont run together? For example: Separating the PC #'s automatically after we sort them? Or have some type of header to show where the info for PC 425 begins/Ends and PC427 begins?
Want this to happen automatically so i dont have to manually separate each time i send out an update on this daily? This is a BIG report for my company that goes to a lot of people. Would like to have it set up to be automatic and clean looking if at all possible. Please help me brainstorm.
Thanks
-
Also… on the sorting. I see where i can sort via your screen shot above, but i do not see that Sort Automatically button. Is that SSFeature a seperate software or download i need to do to be able to do that? i dont see how to set it up automatically? Please advise what i need to do so we will be able to do that automatically.
thanks.
-
@david.saunders Have you looked into creating a row report? It does automatically sort, and you can use the grouping feature to create those separators / headers you also mentioned.
-
Yes, this is a separate browser extension that you download and then it will automatically add the button into SmartSheet for you.
All you need to do is go to
and then click the download button, and then reload SmartSheet, and you will see the "Sort Automatically" checkbox.Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds more features into SmartSheet.
- Report PDF generator that supports grouped and summarized reports
- Automatic sorting, sorting with filters, saving sort settings
- Hiding and unhiding columns, and spell checking
-
I second @Paul Newcome 's suggestion of the row report. If it has to be sorted on the sheet itself, this can be done using Smartsheet Bridge. It's a premium app, but you might check to see if your org already has it as part of your licensing package. Sorting is just one of many things you can do with Bridge.
-
I think Sunbelt Rentals has the Premium package with ya'll. How can I check to see if i have Bridge?
FYI: I got the SSFeathure working with the auto sort. Now i am just trying to put in a more of a report type visual so they are grouped by PC (Profit Center Column). I think that Bridge would work great.. just need to know how to check that. Please advise.
-
You would need to contact your account rep. You can also use the API to do this, but Bridge is a little more user friendly once you get the hang of it.
-
You could check with your account rep to confirm. If you have Smartsheet Advance you should have Bridge, but it will be a separate url specifically spun up for your org. Your account rep should be able to help you find it.
I haven't used SSFeature's extension, but I did note that there's a monthly cost once you complete the trial. Perhaps it's the way to go if this is the only advanced feature you plan to use, but if you already have Bridge or are interested in its additional capabilities, it's also worth considering. And if you can use the report as Paul suggested, that's even better, as it's free and takes seconds to set up.
-
The following is not specifically directed at SSFeatures. As of this post, I have not looked into the program or used it at all. But I have seen other companies advertising add-ons that eventually dropped the ball, and Smartsheet is unable to assist in those cases.
Please keep in mind that not all integrations with Smartsheet are approved by Smartsheet, so make sure you do your due diligence on securities and whatnot before linking any outside program to your Smartsheet account.
.
@Julie Fortney Bridge is only included on Advanced Gold and Platinum. Advanced Silver unfortunately doesn't include Bridge.
-
I think the best way to see the data grouped by the PC is to use a row report, instead of viewing the data from the sheet.
-
We do not have Premium or Gold membership. We were looking at the difference in pricing and all that but i dont even see those names as a option… It just shows Pro, Business and Enterprise. We have the Enterprise package… is that the same as Gold or Premium?
-
Enterprise is your plan level for core Smartsheet. Advance Gold and Premium are packages on top of that that include the premium apps such as Bridge.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives