I'm looking for a formula to put in a top line column cell of a sheet that will collect all of the resources listed in the same sheet in an "assign to" column. The "assign column" is a column list and has named for of various resource. The resources vary by task row.

Goal is to have a list at the top line to show all resources involved in the project. This cell will be linked to another sheet.

How can I best do this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!