Join Collect Function not working
Hello!
I have this formula and it doesn't seem to work:
=JOIN(COLLECT([Capacity-Space Planning]2:[Capacity-Space Planning]245, [Property Name]2:[Property Name]245, [Property Name]@row, Space2:Space245, Space@row))
I'm not sure what I'm doing wring, it's not bring back anything.
Help!
Answers
-
Which range are you trying to join the data from?
-
Hi Paul,
So I've moved the data to another sheet to see if that makes this easier.
=JOIN(COLLECT({DATA || Gables Alternative Classroom Range 4}, {DATA || Gables Alternative Classroom Range 2}, [Property Name]@row, {DATA || Gables Alternative Classroom Range 3}, Space@row))
So I have the [Property Name]@row with is Aresty Building & [Space]@row which is 531
That need to both match and bring me back the Capacity-Space Planning number:
Does that make sense?
-
It doesn't look like the Property Name or Floor columns in the second screenshot are being referenced. Double check your ranges.
-
OK now they are, but still it bring back nothing.
Here it is linked:
And here is shows nothing:
I don't even get an error.
-
What are each of your ranges covering?
-
{DATA || Gables Alternative Classroom Range 4} is the Capacity-Space Planning Number I am trying to bring in.
{DATA || Gables Alternative Classroom Range 2} is the Property Name I am trying to match
{DATA || Gables Alternative Classroom Range 3} is the Space number I am trying to match
-
Double click into each of the 4 cells as if you are going to edit them and take a look at what exactly is in them. Make sure they are an exact match.
How is the data on each sheet being populated?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!