Custom Expression Invalid | Community
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
    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 reply

    2 replies

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

    That did it. Thank you so much!

    Translate
    imgrund
    imgrundAccepted solution
    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
      Terms & ConditionsAccessibility statement

      Loading footer...