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
Jonathan Osgood 3Jonathan Osgood 3 

No matter how many of these I do...

Hi All,

Formula syntax time. Here's the attempt:

AND(NOT(ISPICKVAL(StageName, 'Closed Won'))),
(NOT(ISPICKVAL(StageName, 'Closed Lost'))),
DATEVALUE([Opportunity].CloseDate) -Today() >30 )

The error: The formula expression is invalid: Syntax error. Extra ','

Also, I feel like this criteria should be easier to setup in process builder. The oppprtunity stage criteria is easy enough, but not the "30 days past created date part". Am I missing something there?

Thanks!
Nayana KNayana K
AND(NOT(ISPICKVAL(StageName, 'Closed Won')),
NOT(ISPICKVAL(StageName, 'Closed Lost')),
(DATEVALUE(CloseDate) -Today()) >30 )

this may work