Populate Smartsheet Column from another Smartsheet Column

I am creating a batch of PM sheets. Some of these sheets have columns that will be the use throughout, like Team and Organization. I have sheets where Team members and organizations will be defined. I would like to be able to link the entries in the columns from the Teams and Organization SmartSheet and populate the dropdown list in another sheet.

I believe this is possible with excel, but I am not sure about Smartsheet and if so how to do it.

Thanks in advance.

rick mortellaro | project director | bha technologies | www.bhatech.com


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!