Custom Expression Invalid | Community
Skip to main content
S
seanlewis1
New Participant
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

    S
    seanlewis1Author
    New Participant
    April 28, 2020

    That did it. Thank you so much!

    imgrund
    imgrundAccepted solution
    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")

      Terms & ConditionsAccessibility statement

      Loading footer...