Copy Column to another sheet

subhashgt
subhashgt ✭✭✭
edited 04/17/24 in Smartsheet Basics

Is there any option to copy a specific column to another sheet after met the criteria (Workflow).

SbS

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @subhashgt,

    You can use a cross-sheet reference to bring over data from a specific column in one sheet to a column in another sheet based on a condition set in the destination sheet.

    1. Set Up the Destination Sheet:
      • Add a helper column in your destination sheet that will pull data from the source sheet.
      • In this column, you can use a formula that checks if the row meets your specific criteria and then pulls data from the desired column in the source sheet.
    2. Create a Cross-Sheet Reference:
      • In the destination sheet, in your helper column, set up a formula like =IF([Criteria Column]@row = "Your Criteria", {Source Column Range}, "").
      • Here, [Criteria Column]@row checks the condition in the current row.
      • {Source Column Range} is a placeholder for your actual source column range. You will need to create this reference by clicking on the cell where you want to enter the formula, start typing your formula, and then clicking on the “fx” button to select the range from another sheet.


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @subhashgt

    I hope you're well and safe!

    Unfortunately, it's not possible now, but it's an excellent idea!

    Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

    Potential Workaround

    • Cross-sheet formulas
    • Smartsheet API
    • Premium App, Bridge

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Hi Bassam, this is very useful.

    Could you help me find the mistake I'm making for a similar problem?

    =IF([Unique ID]@row <> "", {Region}, "")

    The Unique ID column is the criterion, basically it must not be blank, the {Region} is where I think it goes wrong. I want it to return the data from the column "Region" in a different sheet, but it doesn't let me select the column, I need to select a specific cell in the column, and then if I convert it to a column formula, it always returns the same cell value.

    How can I make it so each row in the destination has a corresponding row value in the source sheet?