Nested If Formulas

Ask the community Formulas
#1

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!

#2

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"
)
2 Likes
#3

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.

1 Like
#4

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.