If Picklist, Training Type = Customer Paid, and "Opportunity" and/or "Training & PS Record" fields are blank, this formula should type the missing field's label.
Formula:
AND(
ISPICKVAL( Training_Type__c, "Customer Paid"),
IF( !ISBLANK(Opportunity__c ),""," Opportunity; ")&
IF( !ISBLANK(Training_PS_Record__c),""," Training & PS Record; ")
)
Error:
Error: Incorrect parameter type for function 'AND()'. Expected Boolean, received Text
Thanks a lot
3 answers
Try this =
IF(
CASE(
Training_Type__c,
"Customer Paid", 1,
"Training & PS Record", 1,
0
) = 1,
IF(!ISBLANK(Opportunity__c), NULL, " Opportunity; ") &
IF(!ISBLANK(Training_PS_Record__c), NULL, " Training & PS Record; "),
NULL
)
