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
Here is a link to formula help
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000080
Here is the help for the IF https://login.quickbase.com/db/6ewwzuuj?a=dr&r=cm&rl=dvn
In your example since you are testing against just 1 field you can also use the Case function
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=ei&rl=dvy
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000080
Here is the help for the IF https://login.quickbase.com/db/6ewwzuuj?a=dr&r=cm&rl=dvn
In your example since you are testing against just 1 field you can also use the Case function
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=ei&rl=dvy