- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.
- Labels:
-
DemandTools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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", "")))
Senior Customer Success Manager
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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", "")))
Senior Customer Success Manager
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ07-07-2023 01:46 AM
Hi Anthony,
Thank you for your help, will try and get back to you.
Regards,
Hari Vendra

