cancel
Showing results for 
Search instead for 
Did you mean: 

Modify Module - Nested If formula

harikumarvendra
Contributor

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
1 ACCEPTED SOLUTION

AnthonyValidity
Validity Team Member
Validity Team Member

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

 

Anthony Lardiere Jr
Senior Customer Success Manager

View solution in original post

2 REPLIES 2

AnthonyValidity
Validity Team Member
Validity Team Member

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

 

Anthony Lardiere Jr
Senior Customer Success Manager

harikumarvendra
Contributor

Hi Anthony,

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

Regards,

Hari Vendra