Forum Discussion

caito103's avatar
caito103
Icon for Helper I rankHelper I
8 years ago
Solved

Sorting by Month name using month number doesnt work

Hello!   I need hel from you guys. I actually searched abput sort correctly by Month name, creating a Month nummber column and sort the column Month name by Month number, but didt work.     ...
Need Help
  • dramus's avatar
    dramus
    8 years ago

    MesNum is defined as Text. Switch it to Whole Number and that will fix the sort.

caito103's avatar
caito103
Icon for Helper I rankHelper I
8 years ago

Of course! There you go.

 

https://ufile.io/ovfpu

 

Can be that the month order have problem because there are two years with differents months? (2017 have from June until December, and 2018 just have January/February)

 

Thank you so much!

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
8 years ago

MesNum is defined as Text. Switch it to Whole Number and that will fix the sort.

  • caito103's avatar
    caito103
    Icon for Helper I rankHelper I
    8 years ago

    Oh man! Was so simple! With it takes a lot haha, thank you so much!!!