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 using this for ordering.
I have developed a a master list of gear that may be considered to order.
I have made a separate column (column F) as a checklist. I want to be able to check the box in column F and have that row’s date be transferred or repopulated into a new sheet. Is this possible?
iPad Pro
Try this. Add two columns to the right of Table 1, and copy-paste these formulas.
in G2:
=IFERROR(XMATCH(TRUE,INDIRECT($F2))−1+G1,"")
in F2:
=IFERROR(ADDRESS(ROW()+G1,6,,,"WHITES")&":"&ADDRESS(ROWS(WHITES::A),6),"")
in A2: (triple-click on the formula to make sure you get it all at once to copy)
=IFERROR(XLOOKUP(TRUE,INDIRECT($F2),INDIRECT(ADDRESS(ROW()+$G1, COLUMN(),,,"WHITES")&":"&ADDRESS(ROWS(WHITES::A),COLUMN()))),"")
Then copy that formula everywhere in columns A to E.
Since copying an empty cell shows 0, you can create a personalized format with the additional rule that if the content is 0 you don't show anything.
When you see that it works you can hide columns F and G.
Maybe it may be be more simplified.
if I remove the column with the checks, and now create a formula so if the quantity is greater than 0, every row that has a quantity is repopulated into a new sheet?
I just don’t know what formula
Gnodneit wrote:
Yes, but if one wanted to automate it
Am curious why automation is needed here. Are you doing this every few minutes or so?
The efficiency of using the powerful filtering built into the Numbers user interface together with a simple copy-paste (if you need the data in a separate table) is tough to beat!
You could do that 100 times in the time it takes to add extra columns, enter complicated formulas, and debug them.
SG
How about using a Filter? Fast and efficient. Then turn it off to see all your data again.
You could also create a Pivot Table.
SG
Yes, but if one wanted to automate it
How do I repopulate into new sheet
