You need to sign in to do that
Don't have an account?
Jennifer.Schnell
Error: Syntax error. Missing '=' for formula
I am receiving a syntax error for this formula I am building for a node in a PB, I have reviewed this many times and I don't see where I am missing a = sign. The basic logic is - IF record ISNEW or ISCHANGED AND "Industry" = "This" AND "Country" = "THIS. I am a little dyslexic and formulas are my weak spot, I tend to get the syntax backwards.
Error: Syntax error. Missing '='
Error: Syntax error. Missing '='
OR ( AND ( ISNEW (), OR ( TEXT ( [Account].Industry ) = "Chemicals", TEXT ( [Account].Industry ) = "Life Sciences", TEXT ( [Account].Industry ) = "Automotive", ) AND ( TEXT ( [Account].Country__c ) = "Germany", TEXT ( [Account].Country__c ) = "Austria", TEXT ( [Account].Country__c ) = "Switzerland", TEXT ( [Account].Country__c ) = "Luxembourg", TEXT ( [Account].Country__c ) = "Liechtenstein") ), OR ( ISCHANGED ( [Account].Owner.id ), AND ( [Account].Owner.Id ) = "0050f000009WCRoAAO", TEXT ( [Account].Country__c ) = "Germany", TEXT ( [Account].Country__c ) = "Austria", TEXT ( [Account].Country__c ) = "Switzerland", TEXT ( [Account].Country__c ) = "Luxembourg", TEXT ( [Account].Country__c ) = "Liechtenstein") )
Long lists of picklist values make the formula unreadable (very difficult to reveal the errors .. without being dyslexic).
We all face a similar problem.
Using CONTAINS makes that easier.
You have now just two main alternatives ( OR ) with their series of conditions ( AND ).
All Answers
Long lists of picklist values make the formula unreadable (very difficult to reveal the errors .. without being dyslexic).
We all face a similar problem.
Using CONTAINS makes that easier.
You have now just two main alternatives ( OR ) with their series of conditions ( AND ).