Modify Module - Nested If formula

[harikumarvendra]

Hi There,

Can anyone of you help with the below query, please?

I'm trying to create a formula to set the field value in the modify module using IF function but I get the error as "

There seems to be a problem with the formula syntax, please check it over and try again."

I'm trying to build a multiple if condition formula like below:

If Created by = X, Y, Z then update the source field as Sales

Or

If Created by = A, B, C then update the source field as Operations

Or

If Created by = D, E, F, G then update the source field as Marketing etc.

Can anyone help?

Regards,

Hari Vendra

[AnthonyValidity · Accepted solution]

Hi Hari,

How does this work for you?

IF(OR(${CreatedByName}="x",${CreatedByName}="y",${CreatedByName}="z"),"Sales", IF(OR(${CreatedByName}="a",${CreatedByName}="b",${CreatedByName}="c"),"Operations", IF(OR(${CreatedByName}="d",${CreatedByName}="e",${CreatedByName}="f",${CreatedByName}="g"),"Marketing", "")))

[harikumarvendra]

Hi Anthony,

Thank you for your help, will try and get back to you.

Regards,

Hari Vendra