+ Start a Discussion
alok29novalok29nov 

Formula field for opportunity

Hi All,

 

I have a requirement where I need to create  a formula field on opportunity object which reefrs to a custom object.

 

Let me explain it in detail. I have a custom object called Booking quota which has booking amount for different users/Opportunity owners. It is like below one.Let say there are three opportunity user A, B, C.

My object Booking Quota has details like this:

 

Booking Quota



(Opportunity Owner)         Amount



A                                          $100000

B                                          $120000

C                                          $180000

 

Now I have these different opportunity owners on opportunity page. I want to create a formula on opportunity object field let say Booking Amount which populates $100000 if opportunity owner is A and $120000 in case of B.

 

Please tell me how this can be achieved.

 

Thanks

~Alok

 

GRStevenBrookesGRStevenBrookes

Hi,

 

Try this:

 

IF(
OwnerId='ENTER_ID_OF_USER_A',1000000,
IF(
OwnerId='ENTER_ID_OF_USER_B',1200000,
IF(
OwnerId='ENTER_ID_OF_USER_C',1800000,
'')))

 Let me know if this is helpful.

 

Steve

alok29novalok29nov

Thanks for your reply.

 

But I didnot want to hard code it. I want  that amount is entered on Bkkoing_Quota object so that if a user wants to change he can change the amount and it gets populated according to the opportunity owner.