How to do a calculation if there is an empty field
Hello. I am new to calculations and am struggling. Here is the situation. I have a field name "PreferredName". I would like that information filled with the "company name" field data if it is not empty. If the "companyname" field name is empty, then I would like the "preferredname" field to be filled with the data from the "z_fullname" field.
I am trying to put an If statement together but I don't know how to reference if a field is empty. Here is what I tried to do but it didn't work
If (company name) is empty