-
Upvote for Gantt Chart by the Hour
Can I upvote for the Gantt to include feature by the hour? We're coordinating with many subs in every 15 throughout the day and we'd like to be able to track delivery activities by the hour (or every 15 min). In the meantime, we'll be using the calendar feature on Outlook to track these activities.
-
Average formula for cell values calculated from another formula
I'm using the SS Jira connector for Jira and have create a template for my team to use. As part of this template I want to calculate the % completed field based on the task's status (the built in % complete of the gantt project only work at the parent level after manually inputing a value for the child task). I've been…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
Parent Relation on Progress %
Hi, i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates. I have a parent with 6 children rows under it. If i choose the progress bar as a colum property from symbols and select progree in the 6 children, I want the average to be…
-
Is it possible to change the dates for holidays for only one spreadsheet?
I am making one for a schedule in another country and I want to be able to change that without changing the holidays for all of my spreadsheets.
-
Using Gant chart in Powerpoint
I have a request to display the gant chart for a project within a powerpoint presentation. When I export the plan to an image, it appears pretty small and grainy. I would love to pick and choose some rows (I have already collapsed as many as I can) to display to see if the size would be better for the powerpoint slide but…
-
Calendar Day Settings
Is it possible to make individual lines 'Calendar Days' rather than working days? - I have investigated into the project settings and it appears that the calendar dates can only be amended if it changes the whole project? Any advice would be much appreciated.
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
-
Merging MS Project information into SmartSheet Project
I manage a number of projects using SmartSheet for my company. We employ multiple subcontractors and vendors on these projects who use MS Project to manage their activity, but we report on the aggregate project inside our company with SmartSheet. I receive regular (weekly), updated MSP files from the subcontractors, and…
