Skip to main content
seanlewis1
Level 2
Apr 28, 2020 1:04 PM UTC
Solved

Custom Expression Invalid

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.
    imgrund
    imgrundAccepted solution
    Adobe Employee
    Apr 28, 2020 2:51 PM UTC

    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")

    View in thread

    2 replies

    imgrund
    Adobe Employee
    imgrundAdobe EmployeeAccepted solution
    Adobe Employee
    Apr 28, 2020 2:51 PM UTC

    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")

    Translate
      seanlewis1Author
      Level 2
      Apr 28, 2020 3:03 PM UTC

      That did it. Thank you so much!

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...