This formula has been applied to a field called ‘Invoice Contact’, that’s where I want the result to show.
In this case, the formula is only showing data that has been entered into the ‘Invoice Contact Overwrite’ field and for anything that doesn’t have any data, it is showing as blank, rather than adding the Company name.
Am I missing something? We use a variation of this formula to create a ‘Final Fee’ by showing whatever is in our ‘OS Fee’ field, but if our ‘Fee Overwrite’ field has data entered, then the ‘Final Fee’ is updated to whatever is reflected in the ‘Fee Overwrite’ field. This works perfectly. See formula example below.