You need to sign in to do that
Don't have an account?
Andyux
formula compare 2 fields and pick one
Need help with comparing and picking data - thanks!
So I have 2 fields that have numeral data (or maybe blank), FieldA and FieldB. I need a 3rd field FieldAB to populate with this data like this:
If field FieldA, has data, pick it.
If FieldA is blank, select that data from FieldB
If both blank, then FieldAB remains blank (NOT 0)
Something like
So I have 2 fields that have numeral data (or maybe blank), FieldA and FieldB. I need a 3rd field FieldAB to populate with this data like this:
If field FieldA, has data, pick it.
If FieldA is blank, select that data from FieldB
If both blank, then FieldAB remains blank (NOT 0)
Something like
IF( AND( ISBLANK(FieldA__c), ISBLANK(FieldB__c) ),NULL, IF( FieldA__c <> NULL, FieldA__c FieldB__c <> NULL, FieldB__c ), NULL )
All Answers