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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!