Build me a Google Sheet with App Script
Budget: ₹1,500 – ₹12,500 INR
This is an order tracking sheet/ dispatch sheet. I will be using this as a dashboard to make my order prioritization easier. So what i require is that i manually feed in orders. Once the order is shipped, i want the order row to be shifted to another sheet when shipped is selected in the column. Basically, i want the entire row to be deleted from the master sheet and moved to another sheet named "shipped". I would also require another sheet called "ready to dispatch". so when i choose ready to dispatch in the master sheet as the status, i want the entire row to be copied to the ready to dispatch sheet. Please note that i do not require the row to be deleted from the master sheet. Only copy the row to another sheet and delete from both the dispatch and master sheet when i choose shipped on the master sheet. Sometimes my orders have multiple items and some of the items need to be dispatched earlier than the rest. the solution i have for this is to highlight the items that have been dispatched and only remove and shift the entire row once the order has been shipped. You have full autonomy to move/remove anything from the sheet. I have made the headings already for the data that is essential for me