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

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…