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'm making a sheet with items that are the ingredients of a final product, and I want to check that all the ingredients are present before proceeding, so, when this sheet is working properly, all the checked ingredients are checked and the final product availability checkbox becomes checked.
in short.. can I link multiple checkboxes to one master one so that when all needed checkboxes are checked, the product checkbox becomes checked
HI jonpen,
Doable. Up to, but NOT including the last step.
Checkbox cells are 'input only', and accept only one type of input—a mouse click/touch panel tap while the pointer is in the cell.
The value in the cell is toggled between 'true' (checked) to 'false' (unchecked) by clicking the cell.
That click is the only input datum the cell will accept.
You can, however use an 'ordinary' cell to contain a formula that returns 'true' only if all of the required checkbox cells are 'true', then places a checkmark in its cell. Use a conditional highlighting rule to apply a fill colour to the cell containing the formula when the cell contains a checkmark.
Here's an example:
Table 1 contains your inventory. Materials listed on rows with a check are in stock, and available. Those on rows with an empty checkbox are not currently available.
Table 2 contains the formula listing the cells in column B of Table 1 that contain data for each of the materials needed for the items listed in column A of this table.
For convenience in setting up the example, I entered the formula shown in cell B2 of Table 2, then filled it down that column. The result is that each of the items requires three materials: the one in the same row of Table 1 as occupied by the item, plus the ones two and three rows below that. Item 4, for example, requires the materials in rows 5, 7 and 8.
Regards,
Barry
PS: the checkmark shown is in the Bullet...Stars section of the Character Viewer. It can be dragged from there and dropped in the formula (or copied from there and pasted into the formula). Open the viewer by clicking on the button showing the region/keyboard setting of youe computer, then clicking the Emogi and Symbols menu item near the bottom of the menu list.
B
HI jonpen,
Doable. Up to, but NOT including the last step.
Checkbox cells are 'input only', and accept only one type of input—a mouse click/touch panel tap while the pointer is in the cell.
The value in the cell is toggled between 'true' (checked) to 'false' (unchecked) by clicking the cell.
That click is the only input datum the cell will accept.
You can, however use an 'ordinary' cell to contain a formula that returns 'true' only if all of the required checkbox cells are 'true', then places a checkmark in its cell. Use a conditional highlighting rule to apply a fill colour to the cell containing the formula when the cell contains a checkmark.
Here's an example:
Table 1 contains your inventory. Materials listed on rows with a check are in stock, and available. Those on rows with an empty checkbox are not currently available.
Table 2 contains the formula listing the cells in column B of Table 1 that contain data for each of the materials needed for the items listed in column A of this table.
For convenience in setting up the example, I entered the formula shown in cell B2 of Table 2, then filled it down that column. The result is that each of the items requires three materials: the one in the same row of Table 1 as occupied by the item, plus the ones two and three rows below that. Item 4, for example, requires the materials in rows 5, 7 and 8.
Regards,
Barry
PS: the checkmark shown is in the Bullet...Stars section of the Character Viewer. It can be dragged from there and dropped in the formula (or copied from there and pasted into the formula). Open the viewer by clicking on the button showing the region/keyboard setting of youe computer, then clicking the Emogi and Symbols menu item near the bottom of the menu list.
B
"is there an online course to learn all of this?"
Possibly, although not one that I'm currently aware of.
There is the Numbers User Guide, included with your copy of Numbers, and also available for download from Apple Books. 411 pages.
There are several tutorials on specific topics on YouTube.
A duck duck go search for Apple Numbers tutorials brought a large number of positive results.
Udemy, macmost, and YouTube searches also showed several hits.
Regards,
Barry
Yup! this will do what I need.
Thanks, Barry. is there an online course to learn all of this?
Numbers Checkboxes and linking multiple checkboxes
