Multiselect Choices - Pull from Another Smartsheet?

Greetings! Reaching out to the Smartsheet community for assistance with a multiselect question.

I have a Smartsheet that contains a client list, we'll call it Client List. I would like to add a multiselect drop-down to choose the various products that this client subscribes. This product list is maintained in another Smartsheet, we'll call it Product List, and has new items added regularly. Is there a way to have the multiselect in the Client List display all of the products in the Product List ? And automatically include the new Products when added?


Or does the multiselect need to be updated manually?


Thank you for your help!


John

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!