1

I'm having two date time fields FieldA and FieldB and also I'm having a formula field which will hold either one of the two date time fields , if either is filled. But the value is not getting update. It still shows empty. Please find the formula I tried.

IF(
    FieldA!= null,
    FieldA ,
    IF(
        FieldB != null,
        FieldB,
        null
    )
)
1
  • Where does it being shown as empty? What are the values of fieldA and FieldB?
    – kurunve
    Feb 13, 2018 at 11:58

1 Answer 1

1

Use ISBLANK() instead of checking for null.

Below or similar formula would do.

IF(ISBLANK( FieldA__c ), FieldB__c , FieldA__c )

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .