07-06-2023 12:53 AM
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 "
Solved! Go to Solution.
07-06-2023 04:40 AM - edited 07-06-2023 04:41 AM
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", "")))
07-06-2023 04:40 AM - edited 07-06-2023 04:41 AM
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", "")))
07-07-2023 01:46 AM
Hi Anthony,
Thank you for your help, will try and get back to you.
Regards,
Hari Vendra
Get industry news, expert insights, strategies, and hot tips, served up fresh every week.
Visit the Validity blog