Is it possible to create 1 Formula fiel
#Sales Cloudd with 4 different scenarios:
Currently we used PB but the # od Days does not add per day so I am hoping a Formula Field would work and I can eliminate the PB's
LOGIC:
- If User does not have MB User Approval Date, Leave Blank (# of Days to Activation)
- If User Has MB User Approved Date and MB Confirmation Status is False = Calculate the difference between today and the Approval Date
- If the User Has MB User Approved Date and MB Confirmation Status is True and MB Confirmation Dates is not Null, Calculate the difference between MB Confirmation Date and MB User Approved Date
- If the User Has MB User Approved Date and MB Confirmation Status is True and MB Confirmation Dates is Null, Leave Blank (# of Days to Activation)
The formula field (Number) - named "# of Days to Activation"
6 个回答
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Ok then,
Try this with a formula field returning a number:
IF(ISBLANK(MB_User_Approval_Date_Formula__c), NULL,
IF(NOT(Email_Confirmation_Status__c), TODAY()-MB_User_Approval_Date_Formula__c,
IF(NOT(ISBLANK(MB_Confirmation_Date__c)),
MB_Confirmation_Date__c-MB_User_Approval_Date_Formula__c,NULL)))
