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.