-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…
-
Calendar with multiple date colum
Hello: I have prepared a Master Calendar to have all our events in one page. Nevertheless our situation is not that our dates come from different smartsheets but that the dates come from different columns in the smartsheet. Eg. Date #1, Date#2, Date#3 in one line (different columns). This is because sometimes our Xservice…
-
sum column and calculate total to hrs:min
I have a "duration" (used to track time involved) task field that I need to be sum and show on a report as hours:minutes. The column is a drop down field with numbers only in 15 min increments. example: 15 30 45 60 75 90 etc... Appreciate any replies.
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
change task color in filter calendar view
I'm sure this is very simple as I did it for one of my filters but not for the life of me can't figure it out again. Looking to change the color of my tasks in calendar view when I apply a filter. thanks Mike
-
Filtering with Start and End date views
I have filters setup to view different tasks on separate calendars. However it only shows the StartDate. Is there a way to enable EndDate as well?
-
Help wanted
We re looking for a subcontractor to assist in design and implementation of construction scheduling, task management, and resource allocation for a small construction company. Presently, working with Microsoft Project and need to revamp our solution with Smartsheet to be more detailed, efficient, and useable.
-
Working Days without Enabling Dependencies
Is there a way to plug in the Working Days criteria (non-working days, holidays, etc) without turning on Dependencies? I'm trying to build a sheet that recognizes weekends and company holidays as non-working days, but I don't need Predecessors or Duration columns. In the past I've enabled Dependencies then literally…
-
Calendar Formatting
Is it possible to change the formatting options on the calendar. When I print the calendar to PDF, the calendar days are light grey and can be hard to see for some employees. Am I able to adjust the colors, backgrounds, etc. of the calendar view? Thanks
-
Sum hours from multiple sheets based on date ranges
I'm looking to determine how many hours are assigned to specific stage for a given week. Goal being I have "X" number of man hours available for a given week and if I've assigned 300% of that this week but 25% of it next week I need to know I've got shift resources or tasks around. I've got report that shows me all the…