function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Brett Roberts 15Brett Roberts 15 

Formula Field - Account Owner

I need to create a custom formula field on the account that evaluates the owner ID and fills the field out with a text value (a name).

Here is the breakdown I need.

Owner ID 1 = Name 1
Owner ID 2 & 3 = Name 2
Owner ID 3 & 4 = Name 3

Any ideas?
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Brett,

Are you looking only for these owenerids? If yes we can achieve  it by writing simple if condition in formula. Can you confirm it.

Thanks,
Brett Roberts 15Brett Roberts 15
Basically I need the field to fill out a completely separate text value based on the value of the owner ID. As an example, if the owner ID is equal to owner ID 2 or 3, the field would need to populate with a text value of "Tom Smith"

The "Tom Smith" value is not the user that the owner ID belongs to.
Brett Roberts 15Brett Roberts 15
Any ideas?