Month
How can I get a "1" to return for 'Jan' that comes from a form drop down?
Best Answer
-
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)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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".
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
No, still invalid data
-
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Apologies! I see my mistake. One moment.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Trying to create this: Smartsheet demo for dynamic data query on dashboard or portal - YouTube
-
Yes, that second set of formulas worked - thank you! I have been messing with it for hours.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!