Place Months in chronological order on a Dashboard Trendline Chart Widget?

Context: I am building a trendline report to track number of projects started each month. It has two series, a 2024 and 2025 series.

Two keep the months in order, I have put a number in front of the month, e.g. "03. March" so that when I create the trendline the months are not out of order. (e.g. in a previous iteration April was before March).

Question: Is there a way for me to remove the numbers in front of the months while still maintaining the correct calendar order?

For Reference:

This is how I've sorted the data:

This is the formula I used for the months:

=IF(MONTH([Start Date]@row) = 1, "01. January", IF(MONTH([Start Date]@row) = 2, "02. February", IF(MONTH([Start Date]@row) = 3, "03. March", IF(MONTH([Start Date]@row) = 4, "04. April", IF(MONTH([Start Date]@row) = 5, "05. May", IF(MONTH([Start Date]@row) = 6, "06. June", IF(MONTH([Start Date]@row) = 7, "07. July", IF(MONTH([Start Date]@row) = 8, "08. August", IF(MONTH([Start Date]@row) = 9, "09. September", IF(MONTH([Start Date]@row) = 10, "10. October", IF(MONTH([Start Date]@row) = 11, "11. November", "12. December")))))))))))

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!