Bridge - Copy Specific Cells to Another Sheet

Sarah123

I'm trying to use Bridge to copy only 2 cells over to another Smartsheet. I've been trying to create the workflow in Bridge using the how to guides that Smartsheet has on their site but unfortunately I can't seem to get it to work.

Sheet 1 - Has a form that people can enter in when they aren't using their desk in the office

Sheet 2 - Is a "database" to store the desks that others can book

I'd like to only copy the desk number and date from sheet 1 to sheet 2 and not have duplicates in sheet 2. This may have to be multiple bridge workflows which I'm fine with but can't seem to get either to work.

Michelle Choate 2

You might have the form drop the information into the top of the sheet, then use an INDEX/MATCH formula, which will return only the first instance in the sheet if you want to simplify things.

So your second sheet would be the database that people can book desks at. So your Date column formula would look at the DATE AVAILABLE column in your other sheet, and simply be = INDEX([Sheet 1 Date Available}, MATCH( Desk@row, {Sheet 1 Desk Name That is Available},0)

Otherwise @Darren Mullen might be able to answer the bridge question better than I can.

Sarah123

I saw in Bridge that there's a way to copy specific cells from a row to a new sheet, is this not possible? I can use the automation to copy a row over to the new sheet (and hide the columns I don't want) but since Bridge supposedly has this ability I was curious on using it.

Georgie

Hi @Sarah123,

Yes, you can use Bridge to copy certain cells from a row to another sheet - take a look at this help article for the steps to do so: Copy partial rows to another sheet using a Bridge workflow.

To make sure you don’t get duplicates in the target sheet, how about adding a checkbox column in the source sheet and using a formula to check the box for all duplicates of each row (excluding the first instance) - take a look at this thread for an example formula. Once you’ve got that, you should be able to set up a conditional junction in your Bridge workflow, so that it only copies rows where the box isn’t checked.

Hope that helps!

Georgie

Sarah123

Thanks! I tried to follow that how to guide but couldn't seem to figure it out. Is there any other guides with more step by step or photos on each process? @Georgie

Georgie

Hi @Sarah123,

Here are some more Bridge resources which might help you:

• Intro to Bridge Webinar
• Bridge Learning Track
• Bridge Help and Learning

If you’re still having trouble, could you provide some screenshots showing where you’re running into roadblocks in Bridge? These should help us to point you in the right direction or identify what might not be quite right in the workflow.

Thanks,

Georgie