Delete a Row after Sold
6 views
Skip to first unread message
Ron Cercone
Mar 20, 2025, 2:25:46 PMMar 20
to Google Sheets Community
I have an "Inventory" tab with stock numbers of vehicles. And a tab "Customers". In the "Customers" tab I have a column labeled "Delivered" with a Yes/No function.
What I would like is: If Delivered = True, then I want the row in "Inventory" that matches that "Stock Number" to be deleted. I tried to attach a sample file, but it didn't like something.
Valmir
Mar 20, 2025, 3:27:50 PMMar 20
to Google Sheets Community
Dear Ron,
You probably have a column that identifies the vehicle in both tabs (customers and inventory). I think deleting the row is not a good strategy, since it could lead to a deletion by operator error. My suggestion is to put a hidden column in the "Inventory" tab with the Yes/No (you can use "VLOOKUP" for this) and create a filter to display only the rows that have "Yes".
You probably have a column that identifies the vehicle in both tabs (customers and inventory). I think deleting the row is not a good strategy, since it could lead to a deletion by operator error. My suggestion is to put a hidden column in the "Inventory" tab with the Yes/No (you can use "VLOOKUP" for this) and create a filter to display only the rows that have "Yes".
Reply all
Reply to author
Forward
0 new messages