Pull data from one sheet to another when a box is checked.

Options

Hi SS Community,

I'm trying to figure out the best way for data from specific columns in a sheet to get copied to cells in an control center intake sheet.

Thanks,

Kyle

Best Answer

Answers

  • Julio S.
    Julio S. Moderator
    Options

    Hi @Kyle Keever,

    You may easily copy entire rows either manually or by means of an automated workflow as long as you have the right permissions in both the source and target sheets. Bear in mind that rows with predecessors won't copy and, if you have System columns, they will need to be named equally in the source and target sheets (no other type of Column can have the same name as a System Column from the source).

    If you are looking to just selectively map certain column values from the source into the intake target, the best way to accomplish this would be via a DataMesh workflow that maps the desired columns based on a specific value from the source provided that both sheets contain columns with a unique value identifier for each row.

    I hope that these ideas can be of help, but if they aren't, please share some screenshots of your current environment (ensuring that any sensitive information has been hidden).

    Cheers!

    Julio

  • Kyle Keever
    Kyle Keever ✭✭✭✭
    Answer ✓
    Options

    Thanks for the help Julio. I ended up creating another unique column in both sheets and using for an index formula.

  • Kyle Keever
    Kyle Keever ✭✭✭✭
    Options

    @Julio S. Thanks for the additional info. I'd be interested in learning more about the data mesh method. Is that something you could elaborate on or provide an example?

    Thanks

    KK

  • Julio S.
    Julio S. Moderator
    Options

    Hi @Kyle Keever,

    Would you be able to share some captures of your current environment for context? This would allow me to elaborate more on a possible solution with DataMesh.

    Cheers!

    Julio

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!