IF Statement with Two Conditions

Hi there,

I'm trying to get this IF statement to work in the formula tool, basically what I'm looking for is to create a new column based on a department number where it'll calculate a figure based on if one column contains "CUSTOMER" and another column also contains the department number on the same record/line. I'm sure it's something to do with my syntax since it's failing once I type ELSE, but I can't figure it out. Any help is appreciated!

Workflow

Preparation

Accepted answers

alexnajm

You are also missing an ending parentheses right before ELSE

All comments

alexnajm

My guess would be that one of your columns Story Points, Active Minutes, Sum_Capex Points by Team, or Sum_Capex Actual, is not being stored as a number! Can you check that first?

alexnajm

I would also check that Peoplesoft Department is being currently stored as a number and not a string!

alexnajm

You are also missing an ending parentheses right before ELSE

dmpope

Thanks Alex! I knew it had to be a simple fix, now time to get some more caffeine 😅

alexnajm

Happens to the best of us! 😊

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703