Bridge workflow - delete a row when a trigger is met

T Klausner

Looking for guidance and best practice!

High level - We have an intake sheet that includes two columns that have multiple selection dropdowns. In order to separate those data points for reporting, I created regional and channel sheets, along with automations that separate the data fields. All work is done on the intake sheet, the regional and channel sheets are for reporting only, and are updated using Data mesh.

Issue: There is a trigger on the intake that removes the row from the intake sheet when the creative request is deactivated. It's a checkbox. 

Bridge workflow.gif

As of now, I have no way to remove the requests from the channel and regional sheets. I tried to create a Bridge workflow to remove the request from the regional and channel sheets when it's removed from the intake sheet. It works, however only when I add the specific "Row ID". When a new row is added, and the trigger is activated, the workflow does not work because the new has a different "Row ID".

Paul Newcome

Are you able to provide some screenshots for context? Your image won't open for me.