Destination sheet 'Project' column to auto populate values in dropdown form from Source sheet

dsmartsheetuser

• Problem 1: I have Sheet 1, where Projects are tracked with 'Project Name' column and I have Sheet 2 with 'Project Name' column. I would like for Sheet 2 'Project Name' column to reference Sheet 1 'Project Name' values in the form of drop down for user to select.

Sheet 2 has a form, in this form, I will be using the Project Name value for dropdown for user to select.

• Problem 2: This dropdown values should match based on the Type of project. Example: 'Project Name': Test 1, Test 2 are displayed for only 'Project Type': Work from Home. 'Project Name': Test3 and Test 4 are displayed for only 'Project Type': in-office.

Andrée Starå

Hi @dsmartsheetuser

I hope you're well and safe!

Unfortunately, it's not possible now to reference drop-down lists, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Add multiple columns and form logic to show the different ones as needed
• I recently developed a solution with Data Shuttle to keep Dropdown lists automatically updated. It will not get you conditional dropdowns, but it might help to keep them updated

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

dsmartsheetuser

Thank you Andrée for your response. I'll file an enhancement request. I don't have Data Shuttle add-on on my Smartsheet account. So for now, it is manual work.

Thank you,

Deepthi

Andrée Starå

@dsmartsheetuser

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!