Old entries to the top?
Hi all,
I just found out how to put new submissions appear on the top of the sheet, but I have old entries that I want it to be included to the top. I want these changes to apply to the old entries, how can I re-arrange these old entries?
Thanks.
Best Answer
-
I am not sure I follow. Am I correct:
- You have a form that was adding new entries to a sheet at the bottom and you have changed it to put them at the top.
- You now want to sort the existing entries so the oldest is at the bottom.
If that is the case:
- Add a column to your sheet and choose "created date" as your column type.
- Save the sheet.
- The created date will populate with the dates on which the rows were added.
- Select the created date column, right click and choose Sort Rows
- Sort the rows into Descending order.
- The newest entry should be at the top and the oldest at the bottom, with the rest in order, in between.
- You can now remove the created date column, or hide it, if it bothers you.
Answers
-
I am not sure I follow. Am I correct:
- You have a form that was adding new entries to a sheet at the bottom and you have changed it to put them at the top.
- You now want to sort the existing entries so the oldest is at the bottom.
If that is the case:
- Add a column to your sheet and choose "created date" as your column type.
- Save the sheet.
- The created date will populate with the dates on which the rows were added.
- Select the created date column, right click and choose Sort Rows
- Sort the rows into Descending order.
- The newest entry should be at the top and the oldest at the bottom, with the rest in order, in between.
- You can now remove the created date column, or hide it, if it bothers you.
-
Thank you! that worked.
-
Wonderful! Thanks for letting me know.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives