I want to create a custom field on the opportunity level 'Sale Made By'. This should be automatically generated as the user (salesperson) that converted the lead to account.
However, what adds complexity is that I need to be able to edit this field (change who made the sale) in certain cases as system administrator. I understand that it is not possible to edit a formula field given that it is read-only, however I was wondering if there was an easy work around?
At the moment, the field is generated by a simple formula 'CreatedBy.Username', but obviously this means the field cannot be generated.
Any help much appreciated