Trouble creating a text formula based on null fields

As it turns out, since the worker or project name is a required field is that was breaking it. When I may that field unrequited it then worked. Which is fine since the whole point of this is to replace that field. Thank you for the help!