topic Modify Module - Nested If formula in DemandTools

Modify Module - Nested If formula

harikumarvendra — Thu, 06 Jul 2023 07:53:13 GMT

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

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

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

Can anyone help?

Regards,

Hari Vendra

Re: Modify Module - Nested If formula

AnthonyValidity — Thu, 06 Jul 2023 11:41:15 GMT

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

Re: Modify Module - Nested If formula

harikumarvendra — Fri, 07 Jul 2023 08:46:12 GMT

Hi Anthony,

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

Regards,

Hari Vendra