You need to sign in to do that
Don't have an account?
Jonathan 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!
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!
this may work