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 trying to set up my numbers sheet to automatically move a row to a new sheet if a box is checked OR if a cell has certain text in it...
When the checkbox is checked or the last column reads "closed" I want the whole row to be moved to the "closed" sheet.
MacBook Air, macOS 13.4
When using Numbers I would encourage thinking not in terms of "moving" a row from one table to another (note that a "sheet" in Numbers has a blank canvas with tables on it, and it is the tables that have the grids of cells) but in terms of keeping like data together and using filters to view subsets when you need that.
"Moving" data is possible but involves complicated formulas. It's not really natural to spreadsheets, and is prone to error. Applying filters, on the other hand, is simple, powerful, and flexible, and gets you a similar result.
Filter data in Numbers on Mac - Apple Support
Also I'd take advantage of Footer Rows in Numbers for your sums. That will simplify your formulas. You could use, for example, =SUM(C) and =SUM(E).
Add or remove rows and columns in Numbers on Mac - Apple Support
SG
When using Numbers I would encourage thinking not in terms of "moving" a row from one table to another (note that a "sheet" in Numbers has a blank canvas with tables on it, and it is the tables that have the grids of cells) but in terms of keeping like data together and using filters to view subsets when you need that.
"Moving" data is possible but involves complicated formulas. It's not really natural to spreadsheets, and is prone to error. Applying filters, on the other hand, is simple, powerful, and flexible, and gets you a similar result.
Filter data in Numbers on Mac - Apple Support
Also I'd take advantage of Footer Rows in Numbers for your sums. That will simplify your formulas. You could use, for example, =SUM(C) and =SUM(E).
Add or remove rows and columns in Numbers on Mac - Apple Support
SG
Hmm ok. The filters work for that current sheet but I'm needing the whole row, once it's marked closed, to show somewhere else besides that original table. it can move down in the same sheet or to another sheet. I just need it out of that original one. is that possible?
By "sheet" I think you mean "table". A sheet in Numbers has a blank canvas on which you place tables, charts, and other objects.
What are the reasons you need the data to "show somewhere else."? It's typically more efficient to leave it in place and display or not display it as needed.
If you really need the data to "show somewhere else" you can simply filter, select the visible cells, command-c to copy or command-x to cut, click once in a cell of an existing destination table, and command-v or Edit > Paste and Match Style to paste.
SG
Formula for moving a row to another sheet if a certain rule is met
