I am attempting to merge/combine notes either from one sheet or from two different sheets.

Options

Sheet 1 contains a column for "previous" notes that are drawn from sheet 2 and column for "current" notes that are entered manually each week.

Sheet 3 is an archive of all weeks prior. This archive can have multiple "matches" in the primary column.

If the primary column information matches between sheets, I would like to combine the notes from all previous weeks for that criteria in Sheet 2.

I have attempted =join(collect) functions, but cannot seem to combine the information.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!