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.
Multiple Order Tracker
Comments
-
Smartsheet is not a relational database, each row is going to represent one line on an order.
If you are going to use SS, at minimum, you will need columns to id the customer, the quantity and the part number. Unless you have something really simple with limited part numbers and low order flow you would be much better off with something like Zoho, IMHO.
-
Michaela,
I would need to know more about what you are wanting to do. From the information in the post I assume that you recieve the orders as a PDF that is emailed to you. These Orders are multiple item rows.
The only thing you can do on the face of it is to enter the individual rows manually into the sheet all with a single Order number to keep them together. You caluld also have it as a Hierarchy with the top level being the Order Level Details and Titles and the subordinate rows the Row items.
Depending on the security on the PDF you may be able to Copy ad paste the details into smartsheet from the PDF.
As I say need to have more details on the data and how you get it and what you want to do with it.
If you need help with this view my profile and contact us if you wish.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives