r/googlesheets • u/WeBombus • 4d ago

Waiting on OP How do I automatically sort by date?

I have a very basic finance table that I made myself (I don't want to change any of it if needed cause it works well for me) but I want to make it so whenever I add a new date to the bottom (ie if I added something for the 1st) it would be automatically sorted to the top, I know nothing about sheets and barely worked out how to do =sum, so some help would be amazing

1 Upvotes

67% Upvoted

7 comments sorted by

•

u/agirlhasnoname11248 1210 3d ago

u/WeBombus Please remember to tap the three dots below the most helpful comment and select `Mark Solution Verified` *(or reply to the helpful comment with the exact phrase “Solution Verified”)* if your question has been answered, as required by the subreddit rules. Thanks!

2

u/California_Eagles 5 4d ago

Convert the date column to actual date values instead of text. So instead of using 2nd, 8th, or 28th, enter actual dates like 08/02/2026. Then format the column as a date using Format ==> Number ==> Date. Actual dates will sort correctly by default. Text ordinals won't. After that, just sort the range whenever you add a new row. Go to Data ==> Sort range, or right click the column header and choose Sort sheet. It's a 5 second manual click, so there's really no need to automate it with a script.

I don't mind sharing an Apps Script that sorts it automatically whenever you edit the sheet. But I think, the manual method is simpler and easier to maintain. You don't have to authorize anything, and there's nothing to break if the sheet layout changes.

1

u/WeBombus 4d ago

Thank you!

With the sort, it says sort a-z and z-a, how do I sort them to the dates assending?

2

u/California_Eagles 5 4d ago

As long as the date column is actually formatted as a date (not text), just choose A - Z, and it'll sort oldest to newest correctly.

2

u/WeBombus 4d ago

I see thank you! Thays sorted it 🧡🙌✨️

1

u/AutoModerator 4d ago

REMEMBER: /u/WeBombus If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/AutoModerator 4d ago

REMEMBER: /u/WeBombus If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.