Hi SF Community,
I am writing a custom salesforce formula to calculate a total # of days for implementation depending on four factors.
Below is my formual today.
IF(Implementation_Paused__c < DATE(2014,1,1),((SB_Account_Created_Date__c - Implementation_Restart_Date__c) + (Implementation_Paused__c - Onboarding_Start_Date__c)),SB_Account_Created_Date__c - Onboarding_Start_Date__c)
If it's a normal implementation it is two fields:
SB_Account_Created_Date__c - Onboarding_Start_Date__c
however, if it's an implementation where "Impelementation is paused" I want it to run through this order of operations:
((SB_Account_Created_Date__c - Implementation_Restart_Date__c) + (Implementation_Paused__c - Onboarding_Start_Date__c))
How would I explain IF(Implementation_Paused__c, has any field in it, to follow the longer formula?
Thank you in advance,
-Drew
Try this:
IF(NOT(ISBLANK(Implementation_Paused__c)),
((SB_Account_Created_Date__c - Implementation_Restart_Date__c) + (Implementation_Paused__c - Onboarding_Start_Date__c)),
SB_Account_Created_Date__c - Onboarding_Start_Date__c
)
