I'm trying to create a new formula field that will display the date depending on which one of two fields is populated, the two fields are;
First Closed Won Date - First_Closed_Won_Date__c
Close Date - CloseDate
If the opp has a 'First Closed Won Date' then I want that value to display in my new field, but if 'First Closed Won Date' is blank then I want my new field to show the value in the 'CloseDate' field, can anyone help me with this issue?
Leon
4 answers
IF(NOT(ISBLANK(First_Closed_Won_Date__c)),First_Closed_Won_Date__c,CloseDate)