can anybody help with this join(collect) issue?

I created a join(collect) to gatehr all the permits that match the criteria, in this case same account.

The search column [permit type] is looking at a different sheet to find the right permit type.

The join(collect) in column [Number_permits] is working perfectly, that column is capturing all permit numbers of the same account.

I just don't understand why I get a #NO MATCH. I tried so many tricks and I just can't get it to work, what am I missing here?

Looking forward to any response. Cheers



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!