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’
),"")