Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello,
I'm trying to add holiday (complete shut down for 2 weeks) period to my project sheet. I've done it in project settings ect. but it is not showing on my sheet. The project should be that much longer and I was expecting to have a separate bar to appear showing holiday period cutting all tasks started and putting them on hold for that period but this didn't happen. Can anyone help me with thit please?
Many thanks, Gabor
Hi Gabor,
Holidays appear in the Gantt chart as a light pink vertical strip—tasks can be scheduled to start on holidays, but can't be scheduled to end on them.
Holidays won't split or change formatting of the Gantt bars for your tasks; instead the Gantt bars will automatically push out end dates to the next available working day.
The duration column will only count working days (won't count holidays or non-working days).
More info on holidays is available in the help center: https://help.smartsheet.com/articles/516392-defining-working-non-working-holidays-on-a-project-sheet
There currently isn't a way to show custom formatting on the Gantt bars themselves (different color, split task line, etc.) but when you have a moment, please submit a Product Enhancement Request using the form under Quick links on the right of the Community site and let our Product team know that you'd like to see this added.
Hi Shaine,
Thank you very much for your response! I've put away the programme and only started working on it again now we actually started the project so I only saw your reply now.
I'm still struggling with the same issue though. I've put in the dates of the holidays (within settings, working days) but it does not appear any different on the sheet (not pink). I'm probably doing something wrong but can't really figure out what.
Would appreciate your help again!
Thanks,
Gabor
Hi,
I have the same issue, I've configured the holidays (in account settings) but the days are not skipped. I'm new at smartsheet (actually, I'm testing the tool) so, maybe I'm doing something wrong. Can anyone help me? Thanks in advance
Doris
Dear Doris, Shine and Gabor,
I guess, it is a misunderstanding.
I have several workers and they have in different time (from a few days up to several weeks), divided over a year holiday.
It is possible, that one of them works on a large project and only his work on this this project must be interrupted for his holiday.
So I can't set this time as a general holiday, but it is not for the other workers.
Further, I need to see in advance on an overview on which days in a year is he not available.Who can help me?
Thanks in advance.
Laszlo
Hello—
Try using the Team Vacation Planner template in Smartsheet: https://www.smartsheet.com/solutions/team-vacation-planner
With this template, you'll be able to set and plan vacation for your workers (resources).
You might even use this template with Resource Management so that when you assign them to tasks in other sheets (that also have Resource Management enabled), you'll receive an Overallocated badge icon directly in the sheet. More on this functionality here: https://help.smartsheet.com/learning-track/smartsheet-advanced/resource-management
Hi all! I created a report and added it to a dashboard for my staff to review patients with reported falls in the past 7 days. When Admins click on the report link, they can see the report correctly; however, when staff with View Only access click on it, they see only the top row of the report with no content - see…
Is there a quick and easy way to see which users are not receiving automations in a sheet. An email has been sent out to the sheet owner stating a list of users +5 others - but i can't figure out how to see who the 5 others are without manually checking the contact column. Can anyone help Many Thanks
Hello, I am gearing up for the Card view to be deprecated (not super happy about this) and have found an unfortunate issue. I have a team of 23 that I use the Card view to display during our daily standups. As I am trying to transition to the Board view we have found that when I choose certain fields to be displayed in the…
