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
Try this
I suggest a vertical format for readability
Case([Status],
"Contracted","Contracted",
"Contracted Extend","Contracted",
"Location Contracted","Contracted",
"Location Contracted Extend","Contracted",
[Status])
I suggest a vertical format for readability
Case([Status],
"Contracted","Contracted",
"Contracted Extend","Contracted",
"Location Contracted","Contracted",
"Location Contracted Extend","Contracted",
[Status])