IF(
AND(
ISBLANK(
Transfer_to_Production_Date__c,
Pipeline_Successful_Transfer_Date__c
),
IF(
NOT(
ISBLANK(
Transfer_to_Production_Date__c,
)
),
"Warehouse",
IF(
NOT(
ISBLANK(
Pipeline_Successful_Transfer_Date__c
)
),
"Pipeline"
),
)
,
""
))
Please help or tell me where i am going wrong
6 respuestas
Hey Tom. Firstly, ISBLANK can only accept one field at a time and you have two in the first one. Seoncdly, what do you want to return if both thoe fields are blank? Nothing? Maybe try this:
IF(
AND(
ISBLANK(Transfer_to_Production_Date__c),
ISBLANK(Pipeline_Successful_Transfer_Date__c )
), null,
IF(
NOT(ISBLANK(Transfer_to_Production_Date__c)), "Warehouse",
IF(
NOT(ISBLANK(Pipeline_Successful_Transfer_Date__c)), "Pipeline",
null
)
)
)
