May 10, 2022
How do I get my responses from a google form to list in ascending order on my google sheet automatic
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
May 10, 2022
Hi Lori,
In case what you're asking is:
"how can I get form submissions to insert at the top instead of the bottom"
Here's a different post I answered where I explained how to do that with a fairly simple script. You create a new tab called "Form Reversed" and the new entries will be added to the top there.
Here's a different post I answered where I explained how to do that with a fairly simple script. You create a new tab called "Form Reversed" and the new entries will be added to the top there.
https://support.google.com/docs/thread/160200325
Cheers,
Matt
Matt
Community Manager Ritika B recommended this
Hi Lori Spencer,
The results sheet/tab in your file will always appear in ascending order. This allows new responses to be easily appended to the list as the come in. In order to place the items in descending order, you will need to use something like SORT() on a secondary sheet/tab that will show you the items in descending order.
I hope this helps!
Adam
Diamond PE Docs volunteer
Silver PE Classroom volunteer
Cert. Educator 1 & 2
Cert. Trainer
(not a Google employee)
When you've received a response that answers your question, please observe these forum courtesies:
• If you had a Sheets problem, leave your demo sheet shared as View Only as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Community Manager Ritika B recommended this
All Replies (2)
May 10, 2022
Hi Lori Spencer,
The results sheet/tab in your file will always appear in ascending order. This allows new responses to be easily appended to the list as the come in. In order to place the items in descending order, you will need to use something like SORT() on a secondary sheet/tab that will show you the items in descending order.
I hope this helps!
Adam
Diamond PE Docs volunteer
Silver PE Classroom volunteer
Cert. Educator 1 & 2
Cert. Trainer
(not a Google employee)
When you've received a response that answers your question, please observe these forum courtesies:
• If you had a Sheets problem, leave your demo sheet shared as View Only as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Community Manager Ritika B recommended this
Hi Lori,
In case what you're asking is:
"how can I get form submissions to insert at the top instead of the bottom"
Here's a different post I answered where I explained how to do that with a fairly simple script. You create a new tab called "Form Reversed" and the new entries will be added to the top there.
Here's a different post I answered where I explained how to do that with a fairly simple script. You create a new tab called "Form Reversed" and the new entries will be added to the top there.
https://support.google.com/docs/thread/160200325
Cheers,
Matt
Matt
Community Manager Ritika B recommended this