Help with Cross Sheet JOIN(COLLECT) formula

I've built a formula to complete a JOIN(COLLECT). If I put the formula on the same sheet as my column references it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE.

From what I can tell I haven't removed any of the formula delimiters only which sheet I'm referencing.

Any ideas on why I'm unable to get this to work cross-sheets would be greatly appreciated:

Example of Formula when contained in 1 sheet:

=JOIN(COLLECT([POC Status]:[POC Status], [POC System]:[POC System], "RelOne_POC1"), ",")

Example of Formula referencing separate sheet:

=JOIN(COLLECT({POC Client Tracking Range 1}:{POC Client Tracking Range 1},{POC Client Tracking Range 2}:{POC Client Tracking Range 2}, "RelOne_POC1"), ",")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!