I am having formula issue in conjunction with my data table filtering.
I would like to send emails out based on the PO’s (column A) in my DT and then reference the values in columns B - D. The HTML I do understand but I am having issue where more than 1 line has the same PO (row 4 - 7 & row 8 - 11). For these ones, I would like to send just one email to the contact with all 4 lines referenced instead of 4 separate emails. Attachments and screenshots below. Thank you
example sheet.xlsx (8.4 KB)