I currently have a gmail sycn to pull in emails the filter based on a specific subject:
When a response comes in, the subject is Re:.
Is there a way to create a formula that creates a text that will show the initial subject so that I can group them by the email, and than look at it by each thread;
This is the same email thread, but I want the ability to group it within the same.
Hi Erik,
One way to do it would be to create a new formula column, removing the starting 'Re: ’ from the subject line so that they can group together via the new formula column.
thisRow.Subject.RegexReplace("^Re: ","")
I hope this helps!
@Erik_Andersson1 Have you tried grouping by thread id?
That should give you the desired result.
Awesome that worked first try !! Thank you
Chris the thread id works, but only if the subject is the same, which is not always the case.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.