function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Regina PRegina P 

Need help with Formula fields

Hi,

I have created below formula but receiving syntax error as
Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4

Formula:
IF(AND(ISPICKVAL(MA_TA__c , 'Oncology'),INCLUDES( $User.MA_TA_Team__c,'Oncology')),true,false,
IF(AND(ISPICKVAL(MA_TA__c , 'Renal'),INCLUDES( $User.MA_TA_Team__c,'Renal')),true,false,

""
))

Could you please help in sorting out this issue

Thanks,
Regina
CharuDuttCharuDutt
Hii Regina
Try Below Formula
A)
IF(AND(ISPICKVAL(MA_TA__c , 'Oncology'),INCLUDES( $User.MA_TA_Team__c,'Oncology')),true,IF(AND(ISPICKVAL(MA_TA__c , 'Renal'),INCLUDES( $User.MA_TA_Team__c,'Renal')),true,Null))
-------------------------------------------------------------------------------------------------------------------
B)
OR(AND(ISPICKVAL(MA_TA__c , 'Oncology'),INCLUDES( $User.MA_TA_Team__c,'Oncology')), AND(ISPICKVAL(MA_TA__c , 'Renal'),INCLUDES( $User.MA_TA_Team__c,'Renal')))
Please Mark it As Best Answer If It Helps
Thank You!

 
Suraj Tripathi 47Suraj Tripathi 47

Hi Regina

Try This:
 

IF(
    AND ( TEXT(MA_TA__c) = "Oncology" ,INCLUDES(skills__c, "Oncology") ),  true ,

    IF(
        AND ( TEXT(MA_TA__c) = "Renal" , INCLUDES(skills__c, "Renal") ), true , false
    )
)


Please Mark it as Best Answer, if it helps.

Thanks