汽车填第二列选取基于降下来ection using a form

Bradley Casado

Andree, That works! but not for the purpose I intended. I am trying to select from the drop down list (column3) of numbers and have it automatically populate the text (column2) on a separate sheet. for example, If I drop down and choose 10270 then the cell next to it auto populates Access Flooring. Is there any way to do this?

Andrée Starå

@Bradley Casado

Yes, you'd need to change the range and the column to fetch and where it should look for a match.

Let me know if you need any assistance!

Brandon Der

I am also having a hard time getting this to work. I have an employee list sheet and I would like that when a name is put in that it automatically fills out the phone number and email. I have a separate sheet with the colums User, Office, ext, Cell, and email. and idea on how I can make a dropdown menu with all the employee names auto fill the rest of the cells to match? Also is there a way to make a form sheet do that too?

Andrée Starå

Hi@Brandon Der

I'd be happy to take a quick look!

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Ashlyn Melvin

Could this work in a form?

Prabita Chandran

Hi!

I am trying to create a form with two dropdown fields; the values in the second dropdown depend on the selection in the first dropdown and both field values are in columns in a sheet.

The first dropdown is for project lead - this is a text field with about 10 names listed. When the user selects a name, the second dropdown list is populated with all projects that that project lead is leading. In the sheet, I have one column (A) listing the names of PMs and a second column (B) listing the Project Names.

Project Lead - [select a value from the dropdown]

Project Name - [select a value from the dropdown]

For example, in the form, if the user selects "Rick" in the Project Lead dropdown, the form should pull all project names from column B where the value is "Rick" in column A and displays those project names in the form for the user to select from in the second dropdown.

Is it possible to do this and if yes, how do I get this functionality.

TIA,

Prabita

Genevieve P.

Hi!<\/p>

I am trying to create a form with two dropdown fields; the values in the second dropdown depend on the selection in the first dropdown and both field values are in columns in a sheet.<\/p>

The first dropdown is for project lead - this is a text field with about 10 names listed. When the user selects a name, the second dropdown list is populated with all projects that that project lead is leading. In the sheet, I have one column (A) listing the names of PMs and a second column (B) listing the Project Names.<\/p>

Project Lead - [select a value from the dropdown]<\/p>

Project Name - [select a value from the dropdown]<\/p>

For example, in the form, if the user selects "Rick" in the Project Lead dropdown, the form should pull all project names from column B where the value is "Rick" in column A and displays those project names in the form for the user to select from in the second dropdown.<\/p>

Is it possible to do this and if yes, how do I get this functionality.<\/p>

TIA,<\/p>

Prabita<\/p>","bodyRaw":"[{\"insert\":\"Hi!\\nI am trying to create a form with two dropdown fields; the values in the second dropdown depend on the selection in the first dropdown and both field values are in columns in a sheet.\\nThe first dropdown is for project lead - this is a text field with about 10 names listed. When the user selects a name, the second dropdown list is populated with all projects that that project lead is leading. In the sheet, I have one column (A) listing the names of PMs and a second column (B) listing the Project Names.\\nProject Lead - [select a value from the dropdown]\\nProject Name - [select a value from the dropdown]\\nFor example, in the form, if the user selects \\\"Rick\\\" in the Project Lead dropdown, the form should pull all project names from column B where the value is \\\"Rick\\\" in column A and displays those project names in the form for the user to select from in the second dropdown.\\nIs it possible to do this and if yes, how do I get this functionality.\\nTIA,\\nPrabita\\n\"}]","format":"rich","dateInserted":"2021-10-26T23:29:41+00:00","insertUser":{"userID":132089,"name":"Prabita Chandran","url":"https:\/\/community.smartsheet.com\/profile\/Prabita%20Chandran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-15T16:04:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/309004#Comment_309004","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/309004#Comment_309004

Hi@Prabita Chandran

This currently isn't possible to configure in a Smartsheet form - please submit your feedback and suggestion to our Product team byfilling out this form, here!

For the current way that Smartsheet works, you would want to have 10 separate columns, each identifying the Project Names for a specific Lead. Then you can have thefieldappear that's associated with the correct Lead in your Form.

In the underlying sheet, you could hide these 10 columns and instead have one final column showing that uses a formula to check the 10 fields and bring back the selections made.

Cheers,

Genevieve