trying to write a case statement to say when x custom column field is empty/null, then show "None" else show the office related to that record referenced in that field