Need Ideas: How best to organize staff times
We regularly have requests for staff to cover orals or sales meetings. The 'areas' for the staff are consistent (e.g., HR, Payroll, Financials, Technical, etc.), but then for each 'date' there may be a request for HR to be onsite, Payroll to remote - and then we need an indication of which role is needed for which areas and which resources are assigned. Right now I have a sheet where I am keeping the 'Area' frozen and color-coding columns after that, but there has to be an easier way!!!
If I use a 'form' it will give me a row - but I really need a single relationship between what is needed for each area on different days - I may need HR on Monday, but only Financials on Tuesday of this week. And it may be a different combination next week.
Cards, Project Plan, timelines, I'm open to any ideas! Here is what I have so far - but it's clunky.
Answers
-
Hi Annaleah,
So yeah form will always give you a new row but if you want to work on existing rows the only option is request for update. Have you considered it?
The Smartsheet Lover
Is there anything else we can help you with?
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
@kowal that's an interesting approach. The challenge I see is that I don't know what the new dates are…so I might have someone need to add a request for resources for 10/20 or 10/31. Generating that new set of columns (date, mode, client dates/agenda, and resource name) are what is tripping me up. It feels like something I should do on the calendar - BUT since the calendar only shows the primary field, it will always just say the Area with dates, and not show us which clients are causing the overlap or that resources are overlapping.
-
so I think somehow both Forms & Request for Update needs be used in your case.
Form to add new row and if needed the Request for Update needs to be used in this row to collect extra data.
The Smartsheet Lover
Is there anything else we can help you with?
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives