Terminal Resource Allocation
I work for a major international airport and I am trying to set up our ticket counter allocation schedule. I need a 24-hour vertical timeline where the y-axis is hours of the day and the x-axis is swim lanes where each lane is a ticket counter podium. I'd like to be able to enter: "Airline name, podium numbers (can be 2-8 podium positions), begin and end times. And have it plotted on the chart.
This rudimentary spreadsheet is what I'm looking to create in a more professional, easy-to-use format
Answers
-
I am going to encourage you to do your future self a favor and reframe how you are thinking of this.
You should think of this view as a report, and figure out how to manage your data following data normalization rules. With the view of your data that you are showing, I think your columns should be:
Zone; RMS; Position; Start Time; End Time
And your data in those columns will be like:
1; 101; 001; 01:30; 07:30
1; 102; 002; 01:30; 07:30
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 395 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives