Is there a way to auto-group form submissions/rows on the source sheet?
By default, the information that is submitted via a Form populates the Sheet's rows in oldest-to-newest order. I'd like to have the information submitted via the Form auto-group/sort according to the values in one or two of the Sheet/Form fields once it is populated to the Sheet. Would anyone be able to guide me on whether this is possible? Thank you!
Simplified example below of how the data might come in from the Form (with older entries first):
Row - Person - Customer - Submission Date
Row 1 - Seller A - Customer 1 - 1/7/21
Row 2 - Seller B - Customer 2 - 1/12/21
Row 3 - Seller A - Customer 3 - 1/15/21
Row 4 - Seller A - Customer 1 - 1/16/21
Row 5 - Seller C - Customer 4 - 1/18/21
Ideally, I’d like to see this auto-grouped/auto-sorted first by Person and then by customer:
Row - Person - Customer - Submission Date
Row 1 - Seller A - Customer 1 - 1/7/21
Row 2 - Seller A - Customer 1 - 1/16/21
Row 3 - Seller A - Customer 3 - 1/15/21
Row 4 - Seller B - Customer 2 - 1/12/21
Row 5 - Seller C - Customer 4 - 1/18/21
Thank you!
Answers
-
Hi @Alex M2
I hope you're well and safe!
Unfortunately, it's not possible at the moment to auto sort in a sheet, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
As a possible workaround, you could use a report instead.
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) 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!
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
- Customer Resources
- 64.4K 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
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives