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 trying to make an order tracker in a way that if a customer has the boxes “Project Received” and “Payment Collected” both checked then that Customer would automatically move from my Open Orders sheet to my Closed Orders sheet. Is this possible?
MacBook Air 13″, macOS 14.5
Hi GraveWoodworks,
I am working with two tables on one sheet.
When you get all working well, you can select one table and move it (Cut and Paste) to another sheet.
Formula in F2 is IF(AND(D2,E2),"Closed","Open")
Duplicate the Open table (Select the table > Menu > Edit > Duplicate Selection).
I renamed the Duplicate table as Closed.
Formula in Closed A2 is Open::A2
Fill down and fill right.
Now for two different Filters.
For the Open table (The blank rows are still open)
,
For the Closed table (scroll down),
Regards,
Ian.
Moving rows with a checked box to a separate sheet
