Creating multiple dependants drop down menues from another drop down menu

i would like to know if it is possible to create dependant or conditional drop down menues ( in 1 cell )

from another drop down list

iPad Pro, iPadOS 17

Posted on Aug 31, 2024 6:09 AM

Similar questions

Select value in drop menu to populate adjacent cell I want to select value from a drop menu in one cell that will populate the value of the adjacent cell so I select apples from a drop menu and the adjacent cell populates with "3" or some value Looked at conditional formatting - maybe there's a way to use that but it's not obvious THX
1211 2
Creating dynamic dropdown menus in Numbers which are populated from another table(s) What I'm looking to do is have a column called "equipment" and each cell in that column is a dropdown menu the user can select from. And I need the options in that dropdown menu to be dynamically or automatically populated with information coming from another table/sheet of said equipment. So this way, if the equipment list gets updated with new stuff or deleted items, the dropdown menu on the main sheet will reflect the changes automatically. I remember this not being possible about 5 years ago when I looked into it. Is it possible now? Thanks for everyone's time
3214 3
Automatically update pop-up menus in spreadsheet cells Hello. I have a project-pricing spreadsheet for garden construction. I use a reference table to update attributes of materials for example paving slabs, which includes things like supplier cost, unit size, jointing material etc. I create a pop up menu using the reference table including all the types of paving listed, then copy that cell into the main pricing spreadsheet so I can easily select the paving type, which then references all the different attributes such as price, jointing material, unit sizes etc and updates the costs accordingly. When a new material is specified I add it into the reference table, make a new pop up menu including the new material, then copy and paste into the main sheet The issue is I'm costing large projects with many different areas per project, so when I add a new material I'm having to copy and paste into various project elements that may use the product, eg patio 1, patio 2 etc etc. What I'd like to know, is it possible to have a cell reference another cell and be in the format of a drop down menu? Basically so all applicable cells are automatically updated to the new pop up menu but then I'm still able to select an option from that menu? TIA
877 8

1 reply

Camelot

Level 9

60,953 points

Aug 31, 2024 4:19 PM in response to Rocklobang

Unfortunately not. Pop-up menus in Numbers are fixed and need to be predefined. There is no automatic/dynamic lookup to populate the menu options.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Creating multiple dependants drop down menues from another drop down menu

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up