I have a formula field called "Paperwork Due" which is dependent on Case Reason (picklist) and Paperwork Requested field (date). Based on the case reason, the paperwork due will display the specific date. As examples:
If user selects PLOA as the Case Reason, then Paperwork Due is Paperwork Requested + 5 days
I user selects ADA as the Case Reason, then Paperwork Due is Paperwork Requested is + 7 days
All other Case Reason values, then Paperwork Due is Paperwork Requested + 15 days
I have part of the formula, but can someone help me add the other options pretty please? Is it even possible?
IF(
OR(
ISPICKVAL(Reason, "PLOA")
),
Paperwork_Requested__c + 5,Paperwork_Requested__c + 15
)
2 réponses
Hi Nayla, Please try the below
Paperwork_Requested__c +
CASE(Reason,
'PLOA', 5,
'ADA', 7,
15)
