1

I feel like I'm way off but trying to setup a critiera in process builder that determines if the year 2018 from the picklist Year is selected, and the Call Total field has been modified and the record's LastModifiedDate has been changed, the formula evaluates to true.

I'm receiving these errors when trying to save in process builder's criteria box:

Your changes are saved, but you can't activate this process until you resolve the following errors. The formula expression is invalid: Syntax error. Found ')' The formula expression is invalid: Field AidTrack Call is a picklist field. Picklist fields are only supported in certain functions.

ISPICKVAL([AidTrack_Call__c].Year__c,"2018") && 
ISCHANGED(TEXT([AidTrack_Call__c].Call_Total__c=))  && 
Year(DATEVALUE([AidTrack_Call__c].LastModifiedDate)) = Year(Today())

Your help is greatly appreciated.

0

2 Answers 2

3

The second line is invalid:

ISCHANGED(TEXT([AidTrack_Call__c].Call_Total__c=))  && 

It should be:

 ISCHANGED([AidTrack_Call__c].Call_Total__c)  && 

There should not be any need to convert to text, nor did you need the equals sign (if you had needed it, you would have needed a string on the other side).

1
  • Correct, Superb Catch
    – Tilak Raj
    Mar 13, 2019 at 11:43
0

I am also running into the same error The formula expression is invalid: Syntax error. Found ')'

I am trying to create a formula in a flow.

IF ( {!radio_Please_select_a_product} == {!choice_Cornerstone_Support}, "VSS Generic CSSAVES", (IF({!radio_Please_select_a_product} == {!choice_Cornerstone_Subscription_Cloud}, "VSS Generic At_Risk", (IF({!radio_Please_select_a_product} == {!choice_Neo}, "VSS Generic At_Risk", (IF({!radio_Please_select_a_product} == {!choice_SmartFlow}, "VSS Generic At_Risk", (IF({!radio_Please_select_a_product} == {!choice_Other}, "VSS Generic At_Risk", ))))))

1
  • 1
    If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review May 19 at 9:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.