Auto direct risk from master register to project risk

Ide AirTrunk

I have a master risk register with a column controlled by Bridge to update when a new project is spun up in Control Centre.. that way it's easier for people to add risks for a project.

Is there a way to automatically divert the risk from the master register to the respective project register?

I have the project code as metadata..

I was thinking something along the lines of the picture below, but a little stuck on the actual solution!

Really appreciate any help.

cc @Brian_Richardson @Genevieve P.

Ide AirTrunk

I figured it out..

For those wondering, I had a parent workflow like so;

Then I had a child workflow like so;

Super super happy!

Ide AirTrunk

I have got this far so far, but can't crack matching the project ID and then knowing which sheet to direct it to

Ide AirTrunk

@Samuel Mueller I saw you're great with Bridge, wondering if you could help please?

Ide AirTrunk

@Kelly Moore I also note you're great with Bridge, any idea how I could get this working? please.

Ide AirTrunk

Also think something like this might work:

Parent workflow:

and then a childworkflow which searches the sheet for a match of Project ID, and if matches, adds the row?

Ide AirTrunk

@Paul Newcome any idea? also saw you were very good at Bridge.

Ide AirTrunk

I figured it out..

For those wondering, I had a parent workflow like so;

Then I had a child workflow like so;

Super super happy!

Georgie

Hey @Ide AirTrunk,

Thanks so much for posting your solution. I'm glad you were able to work this out!

Georgie

Kelly Moore

Hey @Ide AirTrunk

Nice job on the flow.

One step I sometimes needed was an Array Length step after a Search step, where I could check if the returned array had a length greater than zero - a similar process to using COUNTIFS > 0 in a formula to see if there was a match. The array length step could give me a decision point, especially if I was trying to decide if I needed to update a row vs insert a new row. I'm sure there were more elegant ways to achieve but this way usually worked for me.

Kelly