- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 08, 2024 08:47 AM
Hi community,
I have a formula to combine emails from multiple columns, that generally contain multiple linked records (but not always). This REGEX formula works really well for the first 3 columns, but is failing on the final. Any help on what I'm doing incorrectly would be greatly appreciated!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 08, 2024 09:31 AM
Hey @KFIL!
Please give this updated formula a try:
REGEX_REPLACE(
CONCATENATE(
IF({Moderator Email}, {Moderator Email} & ", "),
IF({ADM Primary Email}, {ADM Primary Email} & ", "),
IF({Other Panelists Email (Primary)}, {Other Panelists Email (Primary)} & ", "),
IF({Other Panelists Alternate Email}, {Other Panelists Alternate Email} & ", ")
),
", $",
""
)
Please let me know if that helps.
Mike, Consultant @ Automatic Nation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 08, 2024 06:02 PM
Thanks! I may have omitted a ",", but also seeing some interference with a lookup field. Once I put into an ARRAYJOIN formula, it worked like a charm! Appreciate the speedy help, @Mike_AutomaticN !!!!
