You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am creating a recipe more than 500 list. I have created a popup menu listing all of the food name. I have created another sheet to list ingredients attributed to the popmenu but I cannot seem to know how to connect the cells to the menu I am selecting. My plan is that I just choose the food name at the top and the ingredients changes as well.
MacBook Pro 13″, macOS 14.5
Here is one way that seems pretty simple. It requires separate tables for each recipe.
Make tables for each receipe like those shown on Sheet 2. These tables have no formulas. They can be on different sheets. You can put them into sheets for Appetizers, Seafood, Pasta, Deserts, and so on if that is helpful. All these tables need to all have unique names (no two the same even if they are on different sheets). You want no blank rows in these tables.
Table 1 needs to be more rows than you will ever have in a recipe. It will not add new rows on its own if a recipe has more ingredients than the table is set up for.
Formulas on Sheet 1::Table 1 are
A3 =IFERROR(INDEX(INDIRECT($B$1&"::A:C"),ROW()−1,COLUMN()),"-")
Copy/Paste that to all the other data cells.
The final step could be to put a filter on the table to show only those rows where column A is not "-"
Hi tg154,
How about placing all your recipes in one table and using the Filter feature in Numbers to show only those rows with the keyword. This method requires Column D with the name of the dish. Column E is to show "Show" if the name of the dish in Column D exactly matches the Pop-Up Menu in C1.
Formula in E3 (and fill down) is IF(D3=C$1,"Show","")
The Filter:
Apply the Filter:
Another example from the Pop-Up Menu:
You can hide Columns D and E.
Regards,
Ian.
I need to caveat this with one important thing: There is a very annoying bug in Numbers where INDIRECT may not recalculate when a new recipe table is made and named and will not recalculate if you add a new row to one of the recipe tables. The INDIRECT functions in Table 1 are supposed to recalculate and show the changes but they may/will not. You can close then open the document to clear it up. You might also be able to switch to a different recipe then switch back to see the changes show up. I hope they fix this bug. Maybe they have in more recent versions of Numbers than what I have (13.1).
Yellowbox wrote:
How about placing all your recipes in one table and using the Filter feature in Numbers to show only those rows with the keyword.
That's why I would do, especially if I had lots of recipes and didn't want dozens of tables littering the document.. The filter feature in Numbers is often overlooked.
SG
Yeah, that's probably the better idea than separate tables.
Numbers - Connecting popup menu to a Cell
