Linking a row of data from one sheet to another sheet
I am trying to automatically bring over a row of data from one sheet to another. Here is my use case:
Sheet A is used to enter new client engagements as the deals are accepted by the client.
Sheet B is used to track our PO's.
We want to automatically add the row of information on the new project from Sheet A as a new Row in sheet B.
What is the best way to do that?
The column headers already match in the two sheets.
Answers
-
I use a template from Smartsheet called Cost Tracking. It moves a row of data from the sheet 'Cost Tracking - Submitted' to 'ITS Infra Cost Tracking - Approved' when I change the 'Cost Approval Status' from Submitted to Approved. It's awesome. Maybe the template can assist you in your project? Hope this helps.
-Jim
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!