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 Antworten
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