Where to put JOIN to append data

Hello everyone,

I have two sheets that I'm working on - the first sheet collates all information supplied by survey correspondents and the second sheet calculates to derive any information needed.

First sheet:

Second Sheet (expected output):

I was able to compose a formula to get the proper count by cross-referencing the above sheets.

However, my formula using JOIN on Properties (second sheet) could not append the second information on the same cell. Any succeeding information with the same team assigned should also be appended.

This is my formula:

JOIN((IF(ISBLANK(INDEX({Property Name}, MATCH([Team Name]@row, {Team Assigned}, 0))), INDEX({Raw Land}, MATCH([Team Name]@row, {Team Assigned}, 0)), INDEX({Property Name}, MATCH([Team Name]@row, {Team Assigned}, 0)))), ",")

Any help will be greatly appreciated on the above.

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!