Q: changing Pop-up-Menu

pop ups in numbers are rather fixed, you can't do dynamic like you can i excel.

Jason

Hi toni,

I have been playing with this idea of conditional pop-ups. This is what I have now. I used rows, not columns. Not the sort of thing I would want to do in bulk. With the 13 rows you can choose 3 aspects. You would use column B to extract data to your data table.

B2= IF(A$1="Red","show","")

B10= IF(A$1="Green","show","")

B7= IF(A$6="Sky","show","")

B8= IF(A$6="Teal","show","")

B9= IF(A$6="Aqua","show","")

That should give you the idea.

Column B can be hidden.  The choice made in A1 determines which of A2, A6 or A10 can be seen. When the filter is on only one "choose shade" row is revealed. Once a shade is selected a quality can be chosen.

Does this seem useful?

quinn

Hi Toni,

Can you take a screenshot, or post the formula giving the error?

quinn

Hi Toni,

I can't see any mistake in your formula. It is not like there is that much to it, either.

Try a restart of your machine and Numbers,

You might start over and if you typed the formula entire last time do as much with your trackpad. is Type "= if" return, with "if-expression" highlighted click A1, Type ="Blue" (with the quotes), click "if-true" type "show" and so on.

I am fishing here the syntax looks fine to me.

quinn

note

the link that worked was: http://img5.fotos-hochladen.net/uploads/bildschirmfotox3ynchqt1j.png

you can load an image directly using the camera icon in the reply window

This solution should work on a Mac- it will not work in a form in iOS (filters do not affect forms).

q

Hi Toni,

I can't see anything wrong with your formula:

B6=IF(A1="Blue","show","")

It also works with quinn's formula that includes a $

=IF(A$1="Blue","show","")

I tried it with Data Format in A as Automatic and Pop-Up Menu. It worked both times.

Regards,

Ian.

Hello

You'd need to use semicolon instead of comma as argument separator in function in German localisation (decimal separator = comma).

E.g.

=WENN(A1=1;1;0)

instead of

=WENN(A1=1,1,0)

H

Thanks H!

That was preying on my mind.

quinn

and pleased that this advice:

You might start over and if you typed the formula entire last time do as much with your trackpad. is Type "= if" return, with "if-expression" highlighted click A1, Type ="Blue" (with the quotes), click "if-true" type "show" and so on.

Would have addressed it.