Help

4x IF(FIND(OR) in a Formula Field (pulling from another Formula field)

Topic Labels: Formulas
Solved
Jump to Solution
1486 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Visnja_Milidrag
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Andrew_Wright
6 - Interface Innovator
6 - Interface Innovator

I would use a Switch Function.

Switch (
{Year/Month}, Jan, “Winter”,
{Year/Month}, Feb, “Winter”,
Etc.

See Solution in Thread

2 Replies 2
Andrew_Wright
6 - Interface Innovator
6 - Interface Innovator

I would use a Switch Function.

Switch (
{Year/Month}, Jan, “Winter”,
{Year/Month}, Feb, “Winter”,
Etc.

Visnja_Milidrag
6 - Interface Innovator
6 - Interface Innovator

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”)))