I am stuck on adding additional values in the "OPEN" and "CLOSED" conditions. I thought it was just "||" but that doesn't seem to trigger the logic the same way. Any help would be appreciated...here is my current code:
OR(
AND(TODAY() > Scheduled_Ship_Date__c, (Line_Status__c = "OPEN" || "AWAITING" || "BOOKED")),
AND(
(Line_Status__c = "CLOSED" || "FULFILLED"),
IF(
AND(
NOT(ISBLANK(Actual_Shipment_Date__c)),
NOT(ISBLANK(Fulfillment_Date__c))
),
IF(
Actual_Shipment_Date__c < Fulfillment_Date__c,
Actual_Shipment_Date__c,
Fulfillment_Date__c
),
IF(
ISBLANK(Actual_Shipment_Date__c),
Fulfillment_Date__c,
Actual_Shipment_Date__c
)
) > Scheduled_Ship_Date__c
)
)
2 answers
Try this:
OR(
AND(TODAY() > Scheduled_Ship_Date__c,
OR(
Line_Status__c = "OPEN".
Line_Status__c = "AWAITING",
Line_Status__c = "BOOKED")
),
AND(
OR(
Line_Status__c = "CLOSED",
Line_Status__c = "FULFILLED"
),
IF(
AND(
NOT(ISBLANK(Actual_Shipment_Date__c)),
NOT(ISBLANK(Fulfillment_Date__c))
),
IF(
Actual_Shipment_Date__c < Fulfillment_Date__c,
Actual_Shipment_Date__c,
Fulfillment_Date__c
),
IF(
ISBLANK(Actual_Shipment_Date__c),
Fulfillment_Date__c,
Actual_Shipment_Date__c
)
) > Scheduled_Ship_Date__c
)
)
