Work around needed for lack of drop down menus in Numbers
I need to be able to transfer information from one page of the worksheet to a summary page in the same worksheet, so that I can print out the summary for my clients. On the first page will be multiple checkboxes so that I can quickly record which product the client desires for each purpose. I don't want to give them this entire form, so I need to transfer to the summary form just the information in the column adjacent to whatever checkboxes are checked during the consultation. I presume there is some sort of formula with an IF-THEN kind of statement, but I am not well versed at these things. Anyone know how to transfer the text of a box to another location ONLY when the adjacent checkbox is checked? Thanks in advance.