Copy Column to another sheet

subhashgt

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

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.

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!

Housing Justice

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?