Need help with this invalid custom expression error | Community
Skip to main content
December 8, 2023
Question

Need help with this invalid custom expression error

  • December 8, 2023
  • 2 replies
  • 961 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.

2 replies

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
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.

KellieGardner
Community Advisor
Community Advisor
December 14, 2023

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