Please assist w/ below Formula.
Current Formula reads:
IF(!From_Portal__c && ISPICKVAL(A__Status_Field__c,"Test"), HYPERLINK("a hyperlink"), "_self"), NULL)
But when Record Type = TestA, I need two additional (A__Status_Field, "Test 2") and (A__Status_Field, "Test 3").
How would I add the additional logic to the current formula?
I'm not sure what you mean. Can you clarify and provide a few examples of what you want for a result?
Are you looking for something like this?
IF(
AND(
RecordType.Name <> 'TestA',
From_Portal__c = FALSE,
TEXT(A__Status_Field__c) = "Test"
),
HYPERLINK("a hyperlink", "_self"),
IF(
AND(
RecordType.Name = 'TestA',
From_Portal__c = FALSE,
OR(
TEXT(A__Status_Field__c) = "Test 2",
TEXT(A__Status_Field__c) = "Test 3"
)
),
HYPERLINK("a hyperlink", "_self"),
NULL))
