function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Smita Hodiggeri (Admin)Smita Hodiggeri (Admin) 

Formula field throwing error Error: Syntax error. Extra ','

Hi Community,

Can someone help me resolve this issue?

My formula field throws error Error: Syntax error. Extra ',' for the following
IF(ISBLANK(ffpsai__BillingEvent__r.Company_ABN__c),'2414235y',ffpsai__BillingEvent__r.Company_ABN__c),IF(NOT(ISBLANK(ABN_Override__c)),ABN_Override__c,'123324')
Tried few parathsis things.  ABN override is a text field
Siva Poreddy 11Siva Poreddy 11
@Smita Hodiggeri (Admin)

Seems parenthesis '(' is missing in the formula, & use " " for string values.


Regards,
 
sreenath reddy 21sreenath reddy 21
Hi  Smita Hodiggeri
Try below code it solve your issue,

IF(ISBLANK(ffpsai__BillingEvent__r.Company_ABN__c),"2414235y",ffpsai__BillingEvent__r.Company_ABN__c),IF(NOT(ISBLANK(ABN_Override__c)),ABN_Override__c,"123324")
Suraj Tripathi 47Suraj Tripathi 47

Hi Smita
find the below solution

IF(ISBLANK(ffpsai__BillingEvent__r.Company_ABN__c),"2414235y",ffpsai__BillingEvent__r.Company_ABN__c) && IF(NOT(ISBLANK(ABN_Override__c)),ABN_Override__c,"123324")

if you find this helpful mark it as the best answer.
Detra HutchinsonDetra Hutchinson

The ISPICKVAL takes two arguments separated by a comma, but you have instead tried using an equals sign.
Incorrect
ISPICKVAL(PRIORVALUE(...) = "value")
Correct
ISPICKVAL(PRIORVALUE(...), "value")

https://www.prepaidgiftbalance.net/
Smita Hodiggeri (Admin)Smita Hodiggeri (Admin)
Both worked for me guys. thank you.