Form dropdown options pulled from another sheet

mmhnpmp1113

Hi!

I would like to make a form with the options pulled from another sheet. This is to prevent an incorrect project code being entered. The column drop-down options would need to be a the list of project codes from another sheet. The drop-down options would need to update continually as new project codes are added to the other sheet. I do not see a formula option for drop-down options so I do not know if this is possible. Basically, I would like the drop-down options to be the list of values from another sheet. If anyone knows how to do this, I would really appreciate the help!

Thank you!

Andrée Starå

https://community.smartsheet.com/discussion/138685/form-dropdown-options-pulled-from-another-sheet

Hi,

I hope you're well and safe!

Do you have access to the Premium App, Data Shuttle?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

mmhnpmp1113

Yes, I do. I do not know what to do to get the dropdown options to be a list from another sheet however. If you could explain that process, I would really appreciate it!
Thank you!