Is there a way to auto-group form submissions/rows on the source sheet?

Alex M2

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!

Andrée Starå

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!