Collecting all 'Assigned to" into 1 cell


Hi, in my project plan I have one column per resource allocated to a task. Is there a way to merge all this names (resources) into a single column as a contact list with multiple entries?

The condition should be that resource respective allocation should be greater than 0.

Thanks a lot in advance



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!