Trying to Use Join and Collect in a function, Says Calculating, but blank result

Options
Terri-Lynn Morrison
Terri-Lynn Morrison ✭✭✭✭
edited 07/09/20 in Formulas and Functions

I am having an issue getting this formula to work for me. This is based off a previous question asked and answered but I can not get it to work for me.


Sheet "1.Master" where I want the consolidated information to go contains [Site No] column (unique identifier/primary column) and a column called "Zoning" among 50 some other columns. [Site No] column is the first column in this sheet.


Sheet "SitePolygons_Zoning" contains [Site No] (not always unique) {SitePolygons_Zoning Range 2}, and [Zoning] {SitePolygons_Zoning Range 1}


Formula based on a prior question/response is:

=JOIN(COLLECT({SitePolygons_Zoning Range 1}, {SitePolygons_Zoning Range 2}, [Site No]1), ",")


When I type in this formula into the column "Zoning" on sheet "1.Master" it says it is calculating, but nothing appears.

Tags:
«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!