I have document that is used for webinar attendance monitoring and our platform has recently changed, and the way copied and pasted chat messages are formatted is different and does not work with our currently formulas. Essentially, the tracking data is monitored on the sheet named "Tracking 3" and when chats are sent in, they are pasted into a separate sheet "AC 3" under a designated column. In Tracking 3, the tracking column referencing to the attendee name in column A, and should search within the designated range on AC 3, lets say column B, for the attendees name within a string. Due to other automated script for resetting the sheet, I am also trying to implement and IF statement, so that if the attendees name is located within the range, to place a "Y" in the tracking column for having received their chat, and "" if a chat was not received by the attendee. I have linked the document below with the ability to comment.
I have tried everything I can think of. With SEARCH, REGEXMATCH, and MATCH. The preexisting formulas are in there as well, but that only works if the pasted chats isolated the attendees name on their own. I have also looked into AppsScript to isolate the attendee name, but I don't believe there is a way to achieve that with the time stamp.
Any assistance or feedback would be appreciated.