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

  • 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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!