Smartsheet connections with count
Good afternoon,
I am trying to see if it is possible to connect 2 smartsheets and have one supply the results from the team working the data.
IE: Business Partner submits request for an area with a unique area ID to be reviewed via a form. Our team then uses the form and goes order by order to review and validate the order. As they add these submissions, the results are counted for the BP's request.
There can be multiple orders for each unique area ID, so if the area ID is ABC123, there may be 4 orders associated with the area. I am looking to count the number of orders that were validated, rescheduled, canceled ect.
Currently I have 2 smartsheets setup with both forms built. The one for my BP includes the name location and a column for each of the options for results by count. The form for my team has a drop down list of each of the possible outcomes and will submit the data including the area ID and each individual order number.
Any assistance would be greatly appreciated.
Comments
-
Hi Joseph,
If I understand your need correct, then it's possible.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
I sent you the screenshots of my sheets(exported to excel).
Basically, if an order comes in from our business process to be verified, they will submit via a form and it will be by the location ID in the first column. On my teams form, they work each individual order for the location ID. Each order will have an individual result. I want the results for each order to count up for the location ID and distribute to each of the columns back to the BP's results sheet. Please let me know if this helps any further.
Thank you!
-
I sent you the screenshots of my sheets(exported to excel).
Basically, if an order comes in from our business process to be verified, they will submit via a form and it will be by the location ID in the first column. On my teams form, they work each individual order for the location ID. Each order will have an individual result. I want the results for each order to count up and distribute to each of the columns back to the BP's results sheet. Please let me know if this helps any further.
Thank you!
-
Thanks!
I'll take a look and get back to you!
Best,
Andrée
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.
-
I have sent you examples of my sheets.
-
Excellent!
I'll get back to you!
Best,
Andrée
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.
-
10-4, I look forward to your help. I still cannot figure it out.
-
Hi Joseph,
Great, that we got it working!
Let me know if I can help with anything else!
Best,
Andrée
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives