Row removed as Workflow trigger
At the moment you have the option for a Workflow to be triggered "When rows are added". I'd really like the option to trigger when rows are removed. Is this on the horizon or is there a workaround?
Thanks!
Best Answer
-
If the row is removed there isn't a row dedicated to perform the workflow on. You can create an alert by counting the rows, and this would allow you to perform an alert/workflow on a static row when rows are added OR removed, or with the use of 2 sheets you can reduce this to only removed, but still only on a single row that checks the entire sheet.
If you are interested in the 2 sheet approach I can go into a little more detail if you like.
Answers
-
If the row is removed there isn't a row dedicated to perform the workflow on. You can create an alert by counting the rows, and this would allow you to perform an alert/workflow on a static row when rows are added OR removed, or with the use of 2 sheets you can reduce this to only removed, but still only on a single row that checks the entire sheet.
If you are interested in the 2 sheet approach I can go into a little more detail if you like.
-
Thanks L@123, that makes sense. I think I'm going to try and figure out a different way of achieving what I need to do!!
-
If you describe your objective a little more I might be able to give you some insight
-
Well, I have a sheet that tracks all our jobs (construction work). I have a helper column that, depending on the status of the job, returns a value of 1 if it's become 'active'. I then have a workflow that sends me the total at the end of the month, and I record that value in a separate sheet. I can then deduct the figures from last month to produce a chart in our dashboard showing how many jobs came to fruition during the month. =IF(OR(Status@row = "Booked In", Status@row = "Completed", Status@row = "Emergency", Status@row = "Monitoring - SMS Ltd.", Status@row = "On Hold", Status@row = "Pending Start Date", Status@row = "Snagging", Status@row = "Work In Progress"), 1, 0)
The only problem arises when jobs are archived and therefore removed from the original sheet. The archived rows can go into a number of different archive sheets, so it's not as simple as having a count of new rows on a single sheet.
I'm not sure if that was coherent, ha ha!
-
How many other sheets are there? You can reference ranges in other sheets and return them to a single sheet fairly simply.
-
I do that already with a lot of other sheets, but I only need to know if a row has disappeared.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!