The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!

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.


Screenshot 2023-04-03 at 19.00.26.png

Thanks a lot in advance

Davide

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!