Skip to main content
I have the following formula... each of the fields below are also formulas... basically, I have two different roles and I want to display one or the other. 

 

When I use this formula, it only shows the AT_Incented_Account_Manager__c and shows a blank for all the records where there there is no AT_Incented_Account_Manager__c. 

 

IF( NOT(ISNULL(AT_Incented_Account_Manager__c)) , AT_Incented_Account_Manager__c, AT_Sales_Executive__c)

 

If I reverse the formula and put the AT_Sales_Executive__c first, it shows those that have that field but not the AT_Incented_Account_Manager__c.

 

I assume that there is a problem with my checking... I guess all of the values are not null for these fields.. however, I have tried the above formula and I have tried <> "" and neither work.

 

Any help is greatly appreciated!!!!!

 

Fred
2 respostas
  1. 25 de jul. de 2012, 12:47
    thanks for replying SteveMo.  I tried your solution and it did not work... I'm thinking that the fields I am using in this formula are also formulas that maybe they are never blank?  I am going to tinker with the other formulas to see if that works.. thanks!!!

     

    Fred