Home

Drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-797625%22%20slang%3D%22en-US%22%3EDrop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797625%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20dependent%20drop%20down%20list%20but%20at%20the%20same%20time%20I%20want%20them%20to%20be%20automated%20(if%20possible).%20For%20example%2C%20say%20I've%20got%20a%20list%20of%205%20car%20makers%20in%20my%20main%20drop%20down.%20Then%20I'll%20get%20to%20choose%20the%20models%20in%20the%202nd%20drop%20down.%20Once%20I've%20selected%20a%20specific%20model%2C%20I%20want%20the%20features%2Fdetails%20of%20this%20model%20to%20show%20up%20in%20the%203rd%20or%204th%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-797625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797725%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389922%22%20target%3D%22_blank%22%3E%40deedz7%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20can%20be%20done%20by%20some%20tricks%20in%20data%20validations%20which%20involve%20the%20named%20ranges%20and%20INDIRECT%20function.%3C%2FP%3E%3CP%3EWatch%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-78bH0RZ7MA%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3Evideo%3C%2FA%3Eto%20learn%20these%20tricks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
deedz7
Occasional Visitor

I want to create dependent drop down list but at the same time I want them to be automated (if possible). For example, say I've got a list of 5 car makers in my main drop down. Then I'll get to choose the models in the 2nd drop down. Once I've selected a specific model, I want the features/details of this model to show up in the 3rd or 4th column.

 

Can this be done?

1 Reply

@deedz7

 

Hi,

 

This is can be done by some tricks in data validations which involve the named ranges and INDIRECT function.

Watch this video to learn these tricks.

 

Regards

Related Conversations
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
9 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
SharePoint List Drag item Move error
mvas111 in SharePoint on
0 Replies
SPO list jumps to top when loading new items
ABehrens in SharePoint Developer on
1 Replies