Skip to main content

Hi! I’m trying to get a field to output one of 4 results based on what it finds contained in a single Formula Field (Date reformatted field to YYYY-MMMM, pulling from the MMMM portion).


If {Year/Month} is “Jan” or “Feb” or “Dec” or “Nov” = “WINTER”

If {Year/Month} is “Mar” or “Apr” or “May” = “SPRING”

If {Year/Month} is “Jun” or “Jul” or “Aug” = “SUMMER”

If {Year/Month} is “Oct” or “Sep” = “FALL”


This is what I tried but I’m getting an error. I managed to get it for one IF(OR) statement but am having trouble linking all four:


IF(

OR(

FIND(

‘Jan’, {Year/Month}

),

FIND(

‘Feb’, {Year/Month}

),

FIND(

‘Nov’, {Year/Month}

),

FIND(

‘Dec’, {Year/Month}

),

‘WINTER’,

IF(

OR(

FIND(

‘Mar’, {Year/Month}

),

FIND(

‘Apr’, {Year/Month}

),

FIND(

‘May’, {Year/Month}

),

‘SPRING’,

IF(

OR(

FIND(

‘Jun’, {Year/Month}

),

FIND(

‘Jul’, {Year/Month}

),

FIND(

‘Aug’, {Year/Month}

),

‘SUMMER’,

IF(

OR(

FIND(

‘Sep’, {Year/Month}

),

FIND(

‘Oct’, {Year/Month}

),

‘FALL’

),"")

I would use a Switch Function.


Switch (

{Year/Month}, Jan, “Winter”,

{Year/Month}, Feb, “Winter”,

Etc.

SWITCH worked. Also found this to work, in the end!


IF(OR(Month=“January”,Month=“February”,Month=“December”),“WINTER”,IF(OR(Month=“April”,Month=“March”,Month=“May”),“SPRING”, IF(OR(Month=“July”,Month=“August”,Month=“June”),“SUMMER”,“FALL”)))

Reply


Terms & Conditions