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

Neil Egsgard

@Sarah123 , the Smartsheet Bridge resources are pretty bad. They don't fully explain how to use the product so your frustration is understandable. I wrote this article about copying attachments to a new sheet. It explains how Bridge works and show the full values use in each Bridge component. You would need to adjust it for copying cell values.

https://community.smartsheet.com/discussion/120291/bridge-copy-all-attachment-names-to-another-sheet-get-data-from-an-array-with-a-child-workflow

Neil Egsgard

@Sarah123 , do you have access to DataMesh, that might be a good solution as well. This is what a Bridge workflow looks like to copy cells to another column.

This is the Junction setup.

• First Value = {{states.startstate.smartsheet.get_row.row.cells.First development hours entry.value}}
  • You would need to change this to your value. I got it from the run log > Get Row >Row > Cells > Specific column I am looking for.
    • Run log is the two arrows on the top right
• Second Value = <blank>
  • I am checking if it is blank

Update row. This is changing the cell value in an existing row. Use Add Row to add a row.

• Sheet
  • This can be the sheet ID of your second sheet
• Row ID
  • This is the row from the trigger
• Cells: This is where you update values
  • Key #1 = The name of your column
  • Value #1 = {{states.startstate.smartsheet.get_row.row.cells.Development hours.value}}
    • This comes from the run log

Neil