How to convert Month Line item in text format to Month Format

Shawnm

Hi All

I have two month line items in text format as shown in picture and want to convert to Month formatted line item.

What steps should I take so that I convert it into Month formatted line item.

Thanks in advance

Accepted answers

HimanshuRaj

Hi @Shawnm

You need to create a month formatted line item
Use the formula, Finditem(Time, Month Stage)

This will give you month formatted line item

Cheers!!

HimanshuRaj

Hi @Shawnm

Sure. Just for the information, If the formula is showing blank then that means your model calendar is not matching with Month stage line item. FINDITEM with time will only populate if model calendar matches with text time.

Cheers!!

All comments

HimanshuRaj

Hi @Shawnm

You need to create a month formatted line item
Use the formula, Finditem(Time, Month Stage)

This will give you month formatted line item

Cheers!!

Shawnm

Hi @Himanshu1998 ,

I tried this already but was getting blanks for some reason. But I did this with some dummy data and it worked. Thank you so much for replying, I'll take a look at the data set to figure why blanks are coming.

HimanshuRaj

Hi @Shawnm

Cheers!!

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…