Month Formula

Highlighted
Super Contributor

Month Formula

Hi Friends,

 

I have a list of Fruits and the month that is sold.

Now someone has entered the month in TEXT format 1,2,3,..., 11,12.

I want it to be Jan, Feb, Mar,...,Nov, Dec.

Writing IF-ELSE is a tedious one. I was trying it in that way.

Can you please highlight some easy way.

 

Sravan_Kumar_0-1585808446962.png

 

4 REPLIES 4
Highlighted
Frequent Contributor

Re: Month Formula

Hi @Sravan_Kumar 

 

First you can create custom month and give code 1  to 12

Panji_0-1585809958188.png

and then in the module you can use format list(Custom Month) to line item Month in Alphabet and then you need to use formula  finditem

 

Panji_1-1585810077537.png

 

regards,

 

Panji

 

 

Highlighted
Super Contributor

Re: Month Formula

Thank You Panji for taking your precious time to help.

 

Please tell me, using this I get the output in List format.

But I want it in Text format.

 

Can you kindly show me the process.

Highlighted
Master Anaplanner/Community Boss

Re: Month Formula

Hi,

 

Create a new line item in text format, Use NAME function to convert list format to text format.

 

Month Alpha Text = NAME(Month Alpha)

 

 

~Vignesh M

Highlighted
Frequent Contributor

Re: Month Formula

HI@Sravan_Kumar 

 

Yes, like @VIGNESH.M say

 

You  just need create a new line item and write formula NAME(line item Month alpha)

 

Panji_0-1585814935997.png

 

Regards,