IF(ISPICKVAL({!currentOpp.Deliver_to_Customer__c},"After"),
IF(({!currentOpp.Deliver_to_Customer_Date__c} - ({!currentOpp.Days_to_Ship_From_Supplier_Lowest__c - 1)) < ({!currentOpp.CloseDate} + {!currentOpp.Supplier_Lead_Time_Days_Modified__c} + 1),
"ASAP", "After"),
"ASAP")
When I save the flow I get "The formula expression is invalid: Syntax error".
I'm using this formula to populate a picklist field that has 3 values: ASAP, After, Before.
{!currentOpp.Deliver_to_Customer__c} = picklist field (on a diff object) that has 3 values: ASAP, After, Before
{!currentOpp.Deliver_to_Customer_Date__c} = date field
{!currentOpp.Days_to_Ship_From_Supplier_Lowest__c = number field
{!currentOpp.CloseDate} = date field
{!currentOpp.Supplier_Lead_Time_Days_Modified__c}
And this is a Text formula. Where am I going wrong???
3 件の回答
It is a flow that is run by a process. The above is within a formula resource in the flow and used to populate one of the fields in a Record Create.
