Month

Dan B_ID

How can I get a "1" to return for 'Jan' that comes from a form drop down?

Andrée Starå

@Dan B_ID

Try this.

=

IF(Month@row = "Jan", 1, 

IF(Month@row = "Feb", 2, 

IF(Month@row = "Mar", 3, 

IF(Month@row = "Apr", 4, 

IF(Month@row = "May", 5, 

IF(Month@row = "Jun", 6, 

IF(Month@row = "Jul", 7, 

IF(Month@row = "Aug", 8, 

IF(Month@row = "Sep", 9, 

IF(Month@row = "Oct", 10,

IF(Month@row = "Nov", 11,

IF(Month@row = "Dec", 12)

Andrée Starå

Hi @Dan B_ID

I hope you're well and safe!

Do you want to convert Jan to 1, Feb to 2, and so on?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dan B_ID

Yes, exactly. I created a form with a drop down question. They select 'Jan' and it enters it into the form. When I use =MONTH(Jan) it gives me 'invalid data'. I want Jan to give me a "1".

Andrée Starå

@Dan B_ID

Try something like this.

=

IF(Month@row <> "", 

IF(MONTH(Month@row) = "Jan", 1, 

IF(MONTH(Month@row) = "Feb", 2, 

IF(MONTH(Month@row) = "Mar", 3, 

IF(MONTH(Month@row) = "Apr", 4, 

IF(MONTH(Month@row) = "May", 5, 

IF(MONTH(Month@row) = "Jun", 6, 

IF(MONTH(Month@row) = "Jul", 7, 

IF(MONTH(Month@row) = "Aug", 8, 

IF(MONTH(Month@row) = "Sep", 9, 

IF(MONTH(Month@row) = "Oct", 10,

IF(MONTH(Month@row) = "Nov", 11,

IF(MONTH(Month@row) = "Dec", 12

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dan B_ID

No, still invalid data

Andrée Starå

@Dan B_ID

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Andrée Starå

@Dan B_ID

Apologies! I see my mistake. One moment.

Andrée Starå

@Dan B_ID

Try this.

=

IF(Month@row = "Jan", 1, 

IF(Month@row = "Feb", 2, 

IF(Month@row = "Mar", 3, 

IF(Month@row = "Apr", 4, 

IF(Month@row = "May", 5, 

IF(Month@row = "Jun", 6, 

IF(Month@row = "Jul", 7, 

IF(Month@row = "Aug", 8, 

IF(Month@row = "Sep", 9, 

IF(Month@row = "Oct", 10,

IF(Month@row = "Nov", 11,

IF(Month@row = "Dec", 12)

Dan B_ID

Dan B_ID

Trying to create this: Smartsheet demo for dynamic data query on dashboard or portal - YouTube

Dan B_ID

Yes, that second set of formulas worked - thank you! I have been messing with it for hours.

Andrée Starå

@Dan B_ID

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!