-
Revising duration so it doesn't count first day
I want the range of days from Monday the 1st to Monday the 21st to read 21 days; yet it reads "22 days" in the duration column. This is because day 1 is the first day, when I need "day 1" to be the following date from the first day. Is there any easy way to fix this? In my job I can never count the first day as day one as…
-
Calculate health of a smartsheet project.
I have created a smartsheet from a project management template. Start and Finish Dates, Durations, predecessor, % complete, are all working well. I can easily calculate the health of completed tasks by allowing a project manager to change the % complete and look at over all weighted averages of those complete tasks. That…
-
Problem with Gant Chart - Gear Icon not consistently shared
Hello All, The gear icon that I see in my gant chart schedule, is not showing up for certain people that I share the sheet with. This is a problem as our project managers need to be able to change the time line displays. Some people can see it, some people cant. I can not find the setting to always allow the gear icon to…
-
Gantt charts open at earliest date for collaborators
Is there any way to have collaborators being able to open gantt charts at today's date instead of the earliest date?
-
Project Sheet nested checklist without duration and dependency
Hello Community, I would like to nest a short checklist of rows under an activity in a Project Sheet such that the nested rows representing the checklist do not require durations and dependencies. However, SmartSheet requires the duration and dependency on each nested row, where I repeat the same data, so it rolls up to…
-
Need Guidance - Can you develop a Generic Project Schedule in Smartsheet
Can you create a generic project schedule in Smartsheet? For example Task 1 starts on Day 1 (start of schedule and month 1) and ends Day 30 (end of month 1), Task 2 starts Day 15 (mid-month 1) and ends Day 90 (end of month 3), Task 3 starts Day 31 (start month 2) and ends Day 180 (end month 6), etc. In Gannt View, you…
-
Gantt - Task Name, Start and End Date
Hi...I would like my gantt chart to show the task name, start date and end date. Is this possible?
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
Cannot change the start date of a whole project
Hi, I have a project with some linked predecessors in it, but some events without. I am trying to make the whole project start later and keep all the relative dates and dependencies. I cannot select all events and drag - I see lots of arrows that seem to loop back to the beginning. I tried creating a new date column with…
-
Work week & calendar days on the same sheet
Hi folks - can anyone tell me how I can have a combination of start/end dates that have standard work week durations (Monday thru Friday) as well as efforts that take weekends into consideration (all calendar days)? I know how to make the Gantt dependencies reflect one or the other but cannot figure out how to make 1…