Interactive Room Map

TK
TK
edited 12/09/19 in Smartsheet Basics

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    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

    Interactive Room.jpg

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    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

     

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Debbie,

    Nicely done! yes

    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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I too love the dashboard idea! yes

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com