Numbers conditional pop-up menu

Dear t quinn,

Could you help me in my problem?

I did a Monthly budget excel, which works very good.

Otherwise I became a Mac user some years ago, and iCloud is very useful nowadays.

I wanted to create the same functions my excel in numbers, but I have some problems 😟

I have got many tables in a sheet.

When I choose a Spending type in B3 I would like to choose from the Spending type's type!
As you see, I choose a Public transport from a list in B5, after that, I would like to choose from the Public transport types Card/ticket in C5 cell.

I'm looking forward your reply!

Thanks,

Attila

Hi Attila,

You have found a very old thread. Sometimes it is best to start a new question. However, here is the best I can offer you.

I hate to say "No you can't do that in Numbers" but Numbers does not support wht I call nested popups. There are some fun workarounds that can be appropriate in different settings, but they involve hiding rows with filters and I would recommend against doing that with a budget.

With Numbers you will be reduced to having all your important subtypes in a single popup. We could simplify your life by auto filling the type itself with something like this:

The subtype popup has all your subtypes not just the ones I have listed.

To auto fill spending type we use LOOKUP()

Table 1-1 in my example would list all subtypes. If you update it you can convert column A to a popup and copy/paste into table one for an updated popup.

I would suggest you put in a feature request by using the Numbers Menu> Numbers>Provide Numbers Feedback.

Sorry there isn't a better solution for you.

quinn

Here's my suggestion; I hope it makes sense.

If I understand you correctly, you want something like this. First, an initial question is displayed:

Then, depending upon the answer, the next question and options are displayed, so that you have either:

or

The way to do this is by having both options in the table, and using a filter to show the appropriate lines. Note that the "Why?" question is line 3, but the "Why not?" question is actually line 4.

I set up a column "C", which will either be "Display" or "Hide", depending upon the result of preceding answer(s). I then used the filter option to only show those rows that have their column C value as "Display". I hid column C for elegance.

Here is column C showing its logical glory:

And here is the filter setting:

You'll want to check the box to the right of the word "Filters" to turn the filter on, and click the "C" in column C to give you the option to hide the column:

And then you should be good to go!

Vince

Hey Vince,

I have been looking at this issue too. I did the same thing over here:

in response to Toni256.87

Great minds and all that.

quinn

Hello, I'm looking for some help around the same thing and trying to make sense of the post that is already here.

I'm basically trying to create an output based on the drop down selections of two cells. Can't seem to figure it out. If a person chooses something from cell A, then they would select another variable in cell B and based on those two combined would output other information.

Any thoughts around this? Thanks!

Hi rene,

You can certainly do that in Numbers. You might get an answer if you post a more specific question.

quinn

Thanks Quinn,

I'm trying to make sense of it myself 🙂 I want to have two cells as in the two screenshots. Picking from the first one and choosing another option from the second cell that corresponds to the first option will ( I'm hoping ) result in a specific set of bullet points in a 3rd cell. Ideally, I'd like to have info that should populate in the 3rd cell located in a separate sheet?

I'm hoping this makes more sense.

Thanks again for helping a novice!

Rene

Hi Quinn,

Looking back on my post, I guess my more specific question would be what would the formula be to get the 3rd cell to pull the appropriate information based on the conditions of cell 1 and 2?

Hi rene,

Here is a method that will use the values in 2 cells to look up another.

Table 1::D2 =INDEX(lookup::$A$1:$D$5,MATCH(B2,lookup::$A,0),MATCH(C2,lookup::$1:$1,0))

The first MATCH() looks in column A of the lookup table for the value in B2. INDEX() uses this to find the lookup row.

The second MATCH() looks in Row 1 of the lookup table for the value in C2. INDEX() uses this to find the lookup column.

Hope this helps.

quinn