Converting Numerical Months Into Month Names

Sigma Formulas and Functions

ztrean August 26, 2020, 7:14pm #1

I have an integer column that represents months (so 1-12) and I was wondering if there was a way I can convert that to month names?

Ryan August 26, 2020, 7:15pm #2

Hey Zachary!

Definitely! You’ll want to use the choose function for this!

The formula would work like this:
Choose([Month],“January”, “February”, “March”…

system automatically bumped October 15, 2020, 3:47am #3

system automatically bumped October 28, 2020, 9:18pm #4

system automatically bumped November 13, 2020, 9:38pm #5

system automatically bumped December 3, 2020, 10:06am #6

system automatically bumped December 22, 2020, 10:19pm #7

system automatically bumped January 12, 2021, 2:09am #8

system automatically bumped February 1, 2021, 10:15am #9

system automatically bumped February 22, 2021, 8:10pm #10