Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How can I add rows from one sheet to another automatically?
I am trying to create a PO / Invoice tracking system for my team. One sheet has all the blanket PO #'s and amounts and the other has all the invoices that are tied to each PO.
So if an invoice is added to the invoice sheet that has a matching PO number to a PO on the PO sheet, the PO amount would decrease by the invoice dollar amount.
Does this make sense?? And does anyone have any ideas on how I can accomplish this?
Comments
-
Hello Meghan! It sounds like you're wanting a conditional move row (such that will move rows from one sheet to another), or possibly a form of the LOOKUP function that can look across multiple sheets—of which we have neither.
I know our Product team is hard at work on both features, but we don't have timeframe for when these will be released in the application.
In the meantime, you might consider looking at a service like Azuqua (https://azuqua.com/) that can facilitate a conditional move row for you.
-
Meghan,
Zapier (www.zapier.com) is a cheaper (and less functional) alternative to Zapier.
It will satisfy your use-case, I believe. I have something similar running using Zapier.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives