Forum Discussion
Quick_BaseJunki
6 years agoQrew Captain
You bet!
You'll need to create a new formula text field with a formula similar to the following, but using your field names.
If([Client]="",[Prospect],[Client])
This will ensure that you are always using the Client field should both Client and Prospect be populated.
After verifying the result looks the way you want, you will change the field type to be Text. It will retain the formula value, but will no longer be a formula. Then you can remove the old fields.
You'll need to create a new formula text field with a formula similar to the following, but using your field names.
If([Client]="",[Prospect],[Client])
This will ensure that you are always using the Client field should both Client and Prospect be populated.
After verifying the result looks the way you want, you will change the field type to be Text. It will retain the formula value, but will no longer be a formula. Then you can remove the old fields.