Automatically remove row in a sheet when cell value changed in the original sheet it was copied from
I have set up a workflow so that when a cell value (checkbox) is changed/checked in one sheet, that row is copied to another sheet.
Is there a way to:
- Automatically remove the row in the sheet it was copied to, when the cell value (checkbox) in the sheet the row was copied from is changed back/unckecked?
Thanks!
Answers
-
It is, but it will require a helper column. If you create a helper column called something similar to "Source Sheet Checkbox Reference" (or something like that so you know what it the column is doing), you could do an INDEX/MATCH to look up the checkbox status on the main page. You'll want to match some key identifier from the row you are on and bring back the checkbox column into your new sheet.
Then you will set up an automation that when rows are changed and the column "Source Sheet Checkbox Reference" changes to Unchecked, delete row.
So 1 helper column, an Index/Match to get the source information, and an automation should do the trick.
-
What automation would you use to delete a row? The only automation I see to delete information is limited to the cell level not the row. Thank you in advance for the help.
-
Sorry, good call out @Garrett.Ricker. You have the option of moving the row to another sheet or copying it. For this purpose I would be inclined to create an archive sheet and use the Move Row feature to move it off of your production sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 60 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives