Skip to main content

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!


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"

)

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.

Reply


Terms & Conditions