Borrowing and Managing Finite Products Across multiple trade shows
Hi,
I've been working on this for a while now and have gotten stuck. Reviewed some of the discussions and nothing that quite meets what I'm looking for.
Premise:
Tradeshow inventory management (borrowing/checking out, etc)
Is there any way to do the follow?
I'd like for the following to happen for each tradeshow:
1) Create a form where they can input the date range and items they'd like at the tradeshow. However, limit the product type they can have based upon inventory status (e.g. if it's checked out by another person or at a show/in transit (12 days prior+ (Show+days at show)+ 12 days) it's not an option for them to use.)
Then also have a check-in form?
I'd also like to create a master report that pulls from each sheet to create an aggregate of how many items are out and at which show. Any way to do this without a dashboard/widget?
Many thanks!
Comments
-
Hi Kristina,
I’ve created something similar for another client to manage orders through different status stage options.
I’d be happy to take a look and see if I can help and you’ll probably give me some ideas as well.
Can you describe your process in more detail and maybe share the sheet(s)/copies of 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)
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
-
@Andrée Starå - was this solution ever found? I am looking to create something similar for my marketing team and am running into the same struggle with how to display availability.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives