Best Of

Hi @Rebecca Panaccione, (and nice to hear from you again!)

You can use a JOIN(COLLECT formula to bring together the information from multiple cells in one sheet to another.

However, before bringing over the dates from your source sheet, you will want to list out the full date range in one cell in the source sheet (such as 1/31/20 - 2/4/20). To do so, you can set up a helper column in your source sheet to just JOIN this information, first:

=JOIN([Start Date]@row:[End Date]@row, " - ")

This will bring your date range together with the " - " symbol, as you have it formatted in your current demo.Then you can create your JOIN(COLLECT with cross-sheet references, referencing this helper column:

=JOIN(COLLECT({Total Date Range in Source Sheet}, {Email/Contact in Source Sheet}, [Email/Contact]@row, {Total A/L in Source Sheet}, >=1), " , ")

You will notice that I built in two different criteria. The formula should read as follows:

• Join together the content of the cells in the column "Dates Together"
• IF
• The Contact in the source sheet matches the contact of my current sheet, in this row
• The Total A/L column in the source sheet has a count greater than or equal to 1
• (this way it won't add in any of your S/L or M/L dates)

Here are some Help Center articles that I used to create this formula:

• JOIN function
• COLLECT function
• Hide Column (for your Helper column)
• Cross-Sheet references

Let me know if you have any questions about this!

Cheers,

Genevieve