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:
As part of my project I am ordering parts with multi-week lead times. I have 3 weeks upcoming that our business will be shut down but that will not affect my vendor's timeline. Can I remove a specific "task" from the project calendar and abide by a standard workweek calendar?
As far as setting the standard work week, have you looked a the project settings? Right click any column headers, then select edit project settings. You can play around with the settings in there to get what you want if I am understanding your question correctly.
For removing the task I would have to see how the sheet is set up in order to give you a better answer.
Sorry about that. I don't think I made much sense originally. I will try to explain it better.
I have attached a screenshot of my Gantt chart. In my project settings I added Thanksgiving and Christmas holidays to "Non-working days" and you can see these shaded.
My task, "Receive F modules" should take 4 weeks starting on 11/21. The vendor I order these parts from is not affected by Thanksgiving or Christmas. Therefore, the finish date should be 12/18.
On my Gantt chart, however, you can see that "Receive F Modules" is affected by my scheduled non-working days.
The work around that I discovered is that I can manually figure out my 4 week lead time (12/18 delivery date) and instead of entering a duration, I select 12/18 as a finish date.
Is this the best way ? Did I do a better job in describing my problem?
There is a help article published that may solve this - basically uses elapsed time rather than something that checks holiday and non-working time. Here is link to article:
https://community.smartsheet.com/discussion/17951/independent-work-days-for-tasks-or-resources
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.
Hello, smarter friends: I'm trying to learn how to utilize automations to move certain rows to new sheets in order to explore if my larger/longer ranging goal is possible. Where I'm Currently Stuck: I can't even figure out how to create functional auto to send a row to a basic sheet. That is my immediate need. But if…
