Help

Nested If Formulas

Topic Labels: Formulas
Solved
Jump to Solution
1008 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sara_Davis
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Community!

I am trying to figure out the following with a nested IF formula- returning a value based on the name of the project. I have 8 different projects to categorize into one of 3 categories.

I keep getting an error message saying to check the formula - what am I doing wrong?
IF({Project}=”Hours”,“Personnel”,
IF({Project}=”Sales”,“Finance",
IF({Project}=”Marketing A”,“Finance”,
IF({Project}=”Marketing B”,“Finance”,
IF({Project}=”Expenses”,“Finance”,
IF({Project}=”Diversity”,“HR”,
IF({Project}=”Life Event”,“HR”,
IF({Project}=”Executive”,“HR”,"Unknown”))))))))

Thank you!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

It could be a curly quote issue, or it could be something else.

I suggest using a SWITCH() instead.

SWITCH({Project},
  "Hours","Personnel",
  "Sales","Finance",
  "Marketing A","Finance",
  "Marketing B","Finance",
  "Expenses","Finance",
  "Diversity","HR",
  "Life Event","HR",
  "Executive","HR",
  "Unknown"
)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

It could be a curly quote issue, or it could be something else.

I suggest using a SWITCH() instead.

SWITCH({Project},
  "Hours","Personnel",
  "Sales","Finance",
  "Marketing A","Finance",
  "Marketing B","Finance",
  "Expenses","Finance",
  "Diversity","HR",
  "Life Event","HR",
  "Executive","HR",
  "Unknown"
)

Thank you SO much!!! I realized it was a combination of formatting issues (curly quotes among others) and also this SWITCH formula made it so much easier.