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


The way my org handles this is to have a second 'override' field that is only editable by our target profiles.

Your formula field would then need to change to be something like this


Not the most elegant solution, but it works for us.


Seems the easiest way would be use WFR or process builder to initially populate the field (Basic Text Field) if null (on creation).

Then you can simply use Field Level Security to make the field viewable by all the users and editable by some. If you want to add a validation rule around when the field can be edited you could add that additional level for those that can edit it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.