Custom Expression Invalid

[seanlewis1]

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?

[AnthonyIm · Accepted solution]

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

[seanlewis1]

That did it. Thank you so much!