How to create an IF statement like in a list
I need to say if ([Status]= "smith" or 'George" or "brown", last name, first name)
Forum Discussion
I had already looked at all of the If statements and didn't find one that would work in my situation. I had used one that works in excel using the If(OR but I kept getting syntax errors. I just used case and this is my formula
Case([Status],"Contracted",Contracted,"Contracted Extend",Contracted,"Location Contracted",Contracted,"Location Contracted Extend",Contracted,[Status])
I am getting a this error.
Formula syntax error
The argument list of the function Contracted must begin with a left parenthesis.
Case