You need to sign in to do that
Don't have an account?
Formula to populate multiple values in a single field
I am trying to take values from multiple fields and populate a value in one field. The goal is to indicate what data sources are populating the account record. My needs are
if only the "AFC_Dealer_ID__c" if not null then populate AFC in the "New Field"
If only the "AutoCount_Reporting_Period__c" if not null then populate "AutoCount" in the "New Field" but if the AFC_Dealer_ID__c and the AutoCount_Reporting_Period__c are not null populte "AFC, AutoCount" in the "New Field"
The otehr two fields needed are below, but for ease of understanding, i only included two of the fields above. There could be 4 values in the 'New Field"
ADESA_Customer_Number__c if not null equals ADESA
Openlane_Org_ID__c if not null equals OpenLane
Hey scotty,
Create a new formula field having some formula like this,
IF(AFC_Dealer_ID__c != null ,'AFC' , '') & IF(AND(AFC_Dealer_ID__c != null ,AutoCount_Reporting_Period__c != null) ,',' , '') & IF(AutoCount_Reporting_Period__c != null ,'AutoCount' , '')
Above formula is for 2 fields, you can make it for four too.
Let me know if it proved useful.
Thanks
RAD
I am not sure whether you have tried 'RAD's suggestion, but sometime != null doesn't seem to work (may be you can dig deep into it to find out).
IF( ! ISBLANK(AFC_Dealer_ID__c),
IF( ! ISBLANK(AutoCount_Reporting_Period__c) , 'AFC, AutoCount', 'AFC'),
IF( ! ISBLANK(AutoCount_Reporting_Period__c) , 'AutoCount', '')
)