Is it true that a % Complete column for a gantt chart can only be updated manually? It would be beautiful if I could use a formula which would update it automatically.
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a business work week schedule. so Mon-Fri no weekends and no holidays. However the GC has agreed he wiil complete his work in exactly…
Is there a way to work on days not normally a workday, ex. work on one saturday. So a 2 day job can be set on friday and saturday, without changing the whole calender of workdays?
Currently I have the ability to manually add holidays to the Gantt view, which default as non-working days. I would like to be able to mark a calendar das a WORKING or NORMAL day, but still have it highlighted (in a color of my choice) on the Gantt view. Ideally, I could even add a description that would show if I move my…
Is it possible to export the whole spreadsheet including the gantt chart into excel? When ive tried to export it to excel previously it only gives me the option to export the actions and not the timeline/gantt chart section. Is this possible?
I want my editors to view the Gantt chart but when they try it says "as an editor or viewer on this sheet, you can not show the Gantt until it has been set up by the sheet owner (Admin). How so I do that so my team can view the calendar or Gantt chart? Thank you,
I'm entering 2 hrs in duration, but over in the gant chartt, it shows 2 days. advice on how to enter/view this corretly?
I've been using smartsheets for projects plans for some weeks now and can manage all of the usual functions that I'm used to but I've got a new challenge. How do i add variable contigency to the duration of a task based on a BRAG status? Example: In an Agile development environment the first pass estimate is RED and should…
I know there is a way to do this but for some reason I am stuck. I have an event taking place on 5/25. So that needs to be the due date and it CAN NOT MOVE. I then have maybe 40 or so tasks leading up to it, all of which have to occur in certain sequences. I am not able to set up the project. One of two problems occurs.…
I have a Team Vacation schedule (the team is working in 4 different countries) and have also added dates for holidays which the company is also off according to the local holidays. Is there a way so that these holidays will show down the Gantt chart so that I don't have to always scroll to where the Holiday is set to see…