JOIN COLLECT Cross-Sheet Formula Not Returning Content

Happy 2024, everyone!

I'm trying to find the error in a JOIN(COLLECT) cross-sheet formula and am overlooking something. Here's the setup:

Sheet 1 - The JOIN(COLLECT) cross-sheet formula is in the Status History field.

Sheet 2 - The helper sheet where a column formula is used in the Status History field to combine the Status and Status Update Date.

The JOIN(COLLECT) cross-sheet formula in Sheet 1 is supposed to pull all the content from the Status History field in Sheet 2, but the formula is not pulling any content from the Status History field. The formula is:

=JOIN(COLLECT({Sheet 1-Status History}, {Sheet 1-ID}, ID@row), CHAR(10))

Thanks in advance for your help!

Lori

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!