Copy Column to another sheet
Is there any option to copy a specific column to another sheet after met the criteria (Workflow).
SbS
Answers
-
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.
- 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.
- 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.
- In the destination sheet, in your helper column, set up a formula like
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"
- Set Up the Destination Sheet:
-
Hi @subhashgt
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
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?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives