+ Start a Discussion
MaheemSamMaheemSam 

Formula field display blank if opportunity owner not equal to createdby

Hi, 

   We have a field called Gross_Margin__c I have to new create a formula field which should be visible on a condition 

    If Opportunity.ownerid == createdid  
      displace Gross_Margin__c
   else 
      Blank
   
  if anyother user logs in they should be able to view Gross_Margin__c  only for opportunity owner based on the condition it must be visible. 
  
 please let me know how to add this logic in formula field. 

Thanks
Sudhir
RD@SFRD@SF
Hi Sudhir,

Try this
IF(Opportunity.ownerid =createdid,Gross_Margin__c,"")
It should do the trick.

Hope it helps
RD
MaheemSamMaheemSam
Thanks for formula one clarfication If other than opportunity owner logs in they should be able to see gross margin even though Opportunity.ownerid =createdid will this formula work?