Interactive Room Map
Hi all
i have a room full of storage freezers. Within each freezer there are 4 shelves of four stainless steel containers. Each container contains 32 positions and each position is a project.
is it possible to start with an interactive “map” of the room, where I can click on any freezer, select a shelf then a container and drill down to whatever project from there?
Conversely could i type type in a search for a project and the Smartsheet would tell me its corresponding freezer/shelf/position??
Comments
-
I am not sure about an actual MAP of the room, but you could list your freezers as parent rows, shelves as children of the freezers, and containers as children of the shelves. Each of the container rows could have a hyperlink to the corresponding project.
Freezer 1
Shelf 1
Container 1
Container 2
.
.
.
Container 32
Shelf 2
.
.
.
Shelf 4
Freezer 2
Shelf 1
.
.
.
.
.
.
So on and so forth...
Would this work?
-
Following on from the Master sheet set up with hierachy as explained in the last reply - You could then set up a Dashboard with Shortcut Widgets laid out in a Room / Freezer like format?
You could Label the Freezers and use reports shortcut and project sheet shortcuts to link the the appropriate files.
This would be visual to a degree...
Just an idea
Kind regards
Debbie
-
also on the dashboard you could use metric widgets to show the position of certain projects containers which are returning lookup funcitons from your main Datasheet.
Happy to help you investigate this further if required.
Kind regards
Debbie Sawyer Consultant & Training Manager
debbie.sawyer@smarterbusinessprocesses.com
-
Debbie,
Nicely done!
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 too love the dashboard idea!
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