How to sort data by date?

Hi guys. I'm hoping someone can help me. I emailed support but got no reply!

I have a sheet with data on it from the beginning of the year. I recently hit sort by ascending and cant change it back. So instead of my data going from 1st- 31st jan. 1st-28th Feb etc its going 01st jan, 01st feb, 01st march and so on.

Any idea how I can sort this problem?

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Olivia Lohan

It sounds like your dates may actually be inserted into a Text/Number type of column instead of a Date type of column, is this possible? Double click on the column name to open up the Column Properties and find out this information.

A Text/Number column will sort by the numbers (ex. 01, 01, 01, 02, 02, 02) whereas the Date column will sort in order of the date (ex. 01, 02, 03, 01, 02, 03).

How is this data being populated into your sheet? Can you change the column to be a Date Type of column, then re-sort once it's the correct type?

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Olivia Lohan

A Text/Number column will sort by the numbers (ex. 01, 01, 01, 02, 02, 02) whereas the Date column will sort in order of the date (ex. 01, 02, 03, 01, 02, 03).

How is this data being populated into your sheet? Can you change the column to be a Date Type of column, then re-sort once it's the correct type?

Cheers,

Genevieve

Olivia Lohan

Thanks so much Genevieve. That solved the problem. Never even thought that was the problem.

Genevieve P.

Wonderful, I'm glad you were able fix it! 🙂

Ed KUMC

Thanks so much Genevieve. it was helpful. Best!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.