I have a standard object with some customer fields.
I have one custom field, complaint received date, when the user will select the date themselves.
I then have 2 fields which need formula input on:
-acknowledgement due field = complaint received date field + 3 working days
-response due field= complaint received date field + 8 weeks
Would anyone be able to help with the formula for these fields? I'm completely stuck!
Thanks!
답변 8개
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Ashley,
Create formula fields returning dates like so:acknowledgement due field:
IF(ISBLANK(complaint_received_date__c),NULL,
complaint_received_date__c+
CASE(WEEKDAY(complaint_received_date__c),1,3,2,3,3,3,7,4,5))
response due field:
complaint_received_date__c+56
