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.
Solved! Go to Solution.
First you can create custom month and give code 1 to 12
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
regards,
Panji
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.
Yes, like @VIGNESH.M say
You just need create a new line item and write formula NAME(line item Month alpha)
Regards,