Skip to main content
New Participant
December 8, 2023
Question

Need help with this invalid custom expression error

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

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