Month Number respective month.

VitthalS · 2025-02-13T14:02:23+00:00

There was an error rendering this rich post.

I want a line item where I can select the month by drop-down. For this respective month I need the number value of the month. How can I achieve this.?

Like October is 10.

I am thinking to create a month flat list and use it, but how can I get the number?

And i would very appreciate you if you share screenshot.

Accepted answers

SriNitya

Hi @002

Use Line item with Month format and then use MONTH() Function.

If you are working on custom time by defining the month number as code and by using CODE() function, you can achieve it.
Hope it helps.

All comments

seymatas1

Hi,

You should use MONTH() function.

I hope this helps.

Seyma 🌷🙂

VitthalS

Hi, @seymatas1

Thanks for replying. But I need Month name as a drop down then respectively I need the number of the month.

Is there any way to do that.

seymatas1

Create another line item that shows the month's name. Concatenate text. (Not the best practice!)

Month Name & Month Number

Create a list with this text.

Instead of replicating Excel documents or doing exactly what was told by the SMEs, I recommend showing other options and communicating around Anaplan's multidimensionality, efficiency, etc.

SriNitya

Hi @002

Use Line item with Month format and then use MONTH() Function.

If you are working on custom time by defining the month number as code and by using CODE() function, you can achieve it.
Hope it helps.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…