Dropdown Lists
7 TopicsDropdown list not showing checkmark
I've created a dropdown list that contains a checkmark and an 'x,' as seen in the images below; when I click on the list, the options don't show either option, as seen in the other image. When I chose either option, the checkmark or the 'x' appears in the cell; it's only in that dropdown menu that it doesn't. Why is that? Is there a way to fix it?539Views0likes0CommentsChoice colum dropdown not working
I have numerous lists on a SharePoint site, all of a sudden none of the choice columns, which should have a dropdown menu, have the arrow allowing a choice to be made from a list, and instead say 'type to filter.' This is happening across all choice columns and all lists? This is happening to all users too. I am using the default SharePoint form.5.8KViews1like5CommentsChange List Selection VBA
Hi Folks! A list of items is stored on one worksheet in a workbook. By selecting an option from a dropdown menu, the item may be copied to another sheet in the workbook. I need to be able to automatically change the selection in the dropdown on the initial worksheet. Can anyone help with this? Thanks!!1.6KViews0likes1CommentData validation lists - flow chart?
Hello, I'm a school leader and I'm trying to create an Excel spreadsheet to track Teaching & Learning action steps that I give to teachers. I understand how to create a drop down list but what I'm trying to do is essentially create a list within a list, like a flow chart. For example: I'm creating a Maths specific tracker at the moment that has 3 dimensions of depth and specific focuses for each dimension. So if I select the dimension of depth as "Language and Communication" then I want a list of Language & Communication focuses to appear to be selected. But if I select the dimension of depth as "Conceptual Understanding" then I want a list of Conceptual Understanding focuses to appear instead. From there I want to be able to type in the action step as normal. I've attached a very basic excel of what I'm looking for. Ideally I'd like to have just one document with a different page for each teacher rather than loads of separate spreadsheets. Is there a way that I can do this?Solved10KViews0likes16CommentsExcel Drop Down List
Is there a way to create a drop down list with Images? I have a library of simple cad profiles that I want to set up as a drop down list. Each image has a designated unique file name. The list will live on a form that needs to be fillout, so instead of describing each image in a drop down list, I would like to show the image829Views0likes1CommentSharePoint Drop Down List Other Option
Hi We have a Sharepoint List and have a field set to "Choice" In option we have the 3 drop down options with the last one being "other" We have Allow 'Fill-in' choices tick to YES We basically want people to be able to being a list of the top 3 most common options but if they need they can type in a answer. This works, however during testing we noticed that when we put in a manual entry for the "other" it saves it and then next time we add another new list the previously added "other" option is added to the drop down this. eg original drop down option 1 2 3 other Create a new item in the list and during the creation of the entry on the drop down list manually add a entry of 4 When you create another new item you dropdown will now give the following option 1 2 3 4 ** other So 4 was added because there is a item in the list with the number 4 in Is there a way to stop this happening, so the drop down list is always kept to 1 2 3 other But also allow us to manually add a entry?7.7KViews0likes1Comment