Skip to main content
New Participant
December 8, 2023
Question

Need help with this invalid custom expression error

  • December 8, 2023
  • 6 replies
  • 964 views

What is wrong with this custom expression? IF({portfolio}.{name}="CNS CE - Customer Engagement", "CE"),

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

6 replies

KellieGardner
New Participant
December 14, 2023

@rpgmf - What kind of custom form (project, task, issue, etc.) is it that you are trying to use the calculate field? 

lgaertner
Level 9
December 8, 2023

Hello RPGMF,

 

this expression is correct, if you try it in a calculated field in a custom form.

In textmode it also works as

valueexpression=IF({portfolio}.{name}="CNS CE - Customer Engagement", "CE")

 

Where did you try to use it and do you get any error message / response?

 

Regards

Lars

RPGMFAuthor
New Participant
December 8, 2023


It's being used in a calculation field. I am unable to save and close the custom form and keep getting the error message - This is an invalid custom expression, please try again.

lgaertner
Level 9
December 8, 2023

I would cut and paste it into a text editor, copy from there and paste it back into the calculation expression to eliminate any hidden characters.