I am trying to find the lessor of two date fields, then comparing that "lessor" date field to another date field to trigger a checkbox on/off.
Here is the current formula, however, im trying to figure out how to find the lessor of the two date fields (
Actual_Shipment_Date__c and Fulfillment_Date__c) before comparing it to
Scheduled_Ship_Date__c in the second nested
IF( OR( AND(TODAY() > Scheduled_Ship_Date__c, (Line_Status__c = "OPEN")), AND( OR( Actual_Shipment_Date__c > Scheduled_Ship_Date__c, Fulfillment_Date__c > Scheduled_Ship_Date__c ), (Line_Status__c = "CLOSED") ) ), True, False )