How To Create Form Fields In Smartsheet

[@AbhishekKumar-pk5ej]

Buddy do you have a solution for selecting drop down list in a coloumn of a sheet from a source sheet. Once the source sheet is updated the drop down in the destination sheet should also be updated. I was looking at Cheetah Apps but im sure it will come for an additional monthly subscription which I want to avoid. Any suggestion will be greatly appreciated.

[@workflowmyworkload]

Hey! there are 2 ways to go about this within Smartsheet, and they both require a Smartsheet premium app: Smartsheet DataShuttle or Smartsheet Bridge. Check with your existing Smartsheet plan to see if you already have one of these, and if so, I would start with Smartsheet DataShuttle. (Bridge is great but way more complex as it is their open API app). Have an excel sheet that houses your column(s) with the most up to date information, and then set up Smartsheet DataShuttle to have that excel sheet update automatically your Smartsheet column dropdown list. Here are links to DataShuttle and Bridge: DataShuttle Dropdown updating: help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle Bridge: help.smartsheet.com/articles/2482712-update-dropdown-columns