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
Kevin RomeisKevin Romeis 

IF formula receiving syntax error missing ')'

Hi all,

using the IF formula:  I keep receiving a missing ')' syntax error.   what am i doing incorrectly?   thanks
IF(ISPICKVAL(StageName, "nurture", IMAGE("<URL>"),
IF(ISPICKVAL(StageName, "sent to sales",IMAGE("<URL>"),
IF(ISPICKVAL(StageName, "proposal",IMAGE("<URL>"),
IF(ISPICKVAL(StageName, "Returned",IMAGE("<URL>"),
)
)
)
)
 
Shailesh DeshpandeShailesh Deshpande
I guess you are missing the ) at the end of each ISPICKVAL. Once you add that, you will also have to specify the value if last IF condition turns out false.
  
IF(ISPICKVAL(StageName, "nurture"), IMAGE("<URL>"),
	IF(ISPICKVAL(StageName, "sent to sales"),IMAGE("<URL>"),
			IF(ISPICKVAL(StageName, "proposal"),IMAGE("<URL>"),
				IF(ISPICKVAL(StageName, "Returned"),IMAGE("<URL>"), // value if false
)
)
)
)

Thanks,
Shailesh.