Month to Number
I have a month field that I would like to switch to a number for sorting.
I have tried a bunch of different calculations to try and get the Month field to turn into a number but haven't been successful.
Best Answer

The basic idea of the formula that Itai provided is the one to use. However, since the month is just a text string, you don't need the month function (which works on dates, not text). Try this format; keep going until all of the months are present:
=IF(Month@row = "January", 1, IF(Month@row = "February", 2))
Hope this helps!
Answers

Hey,
Try this formula: =IF(MONTH([month]@row) = "January" , "1", IF(MONTH([month]@row) = "February", 2....))
Keep writing this formula for all of the months.
Itai Perez
Project Manager  Transformation Department
Gong cha
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

I have tried this formula and it doesn't work, I get UNPARSEABLE error. The month is being populated via a drop down box, I am not sure if that is making a difference. The information is being populated via a form.

The basic idea of the formula that Itai provided is the one to use. However, since the month is just a text string, you don't need the month function (which works on dates, not text). Try this format; keep going until all of the months are present:
=IF(Month@row = "January", 1, IF(Month@row = "February", 2))
Hope this helps!
Help Article Resources
Categories
Check out the Formula Handbook template!