Custom Expression Invalid | Community
Skip to main content
S
seanlewis1
Level 2
April 28, 2020
Solved

Custom Expression Invalid

  • April 28, 2020
  • 2 replies
  • 654 views

I have a User Custom Form and am attempting to add a calculated field. I entered the following If statement but it is invalid : IF({Manager ID} = "5dae0209016d5a41c078ff1296c5ae63", "Design", "Media")

I'm not sure if the field name needs to be written using text mode format or if it's another issue. Can anyone help?

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

    Hi - so first, there are a lot of spaces in your formula. The only one you need is between Manager and ID.

    Also, for a custom field on a custom form, you don't need the brackets. That is just for reporting and Views where you are doing a calculation in a column.

    So just try IF(Manager ID="5dae0209016d5a41c078ff1296c5ae63","Design","Media")

    2 replies

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAccepted solution
    Adobe Employee
    April 28, 2020

    Hi - so first, there are a lot of spaces in your formula. The only one you need is between Manager and ID.

    Also, for a custom field on a custom form, you don't need the brackets. That is just for reporting and Views where you are doing a calculation in a column.

    So just try IF(Manager ID="5dae0209016d5a41c078ff1296c5ae63","Design","Media")

      S
      seanlewis1Author
      Level 2
      April 28, 2020

      That did it. Thank you so much!

      Terms & ConditionsAccessibility statement

      Loading footer...