-
Using Salesforce connector to sync go live dates and drive dependencies
Hello Smartsheet community, My team uses Salesforce as the system of record to help identify which Salesforce projects will be provisioned in Control Center. One of the problem areas is that go-live dates can shift and it's a pain to update the Smartsheet side if I'm already using Salesforce Connector to pull in the Target…
-
Lock a date even if it has predecessors
I love the predecessor functionality, because it does help make things easier when dates need to shift. However, there are certain dates that cannot be shifted sometimes (a key milestone that has to be met, or a meeting with execs that will take place on a certain day). I wish there was a functionality to LOCK those dates…
-
Listing dependencies by action number
I am currently maintaining an action/deliverables register with approximately 500 line items. Each line item has a corresponding unique action ID code (e.g. AE11.02.01), which contains useful information regarding the relevant business area and related topic. Currently any dependencies are listed by row number and is only…
-
Dependency columns: Automations or Formulas in Start / Finish & Duration Columns
With so many posts about this why has this feature not been added or fixed? The fact that this is not a feature in Smartsheet makes it extremely difficult and inefficient to accurately determine schedules. We are utilizing Smartsheet to build out our schedule the production and forecast the completion of our products. All…
-
One project template, one set of dependencies and duration, but different start dates
Hi - I'm trying to create one project template, where tasks are the same, have the same dependencies and duration but the start dates may differ based on the project's complexity. One project has a longer lead time to kick things off from the other. And for the less complex variation, some of the timeline is compressed due…
-
Merged: Successors
This discussion has been merged.
-
Change How Dependencies Appear? - Would rather see task title vs row number
My engineers and technical team(s) have requested a bounty list be created. Obviously setting up a dependency is easy enough; however, it would be be more useful to see the task name that the task is dependent upon instead of the row number. Is there a way to do this by changing a setting that I don't know about? Or would…
-
Why is PROJECTED COMPLETION DATE Column Autopopulating with Date After Date Assigned
One of my PMs has noticed that the date in the PROJECTED COMPLETION DATE column on an assignment tracker is autopopulating with a date one day after the DATE ASSIGNED date. We have dependencies turned on to utilize Resource Management functionality with the sheet, but aren't using the PREDECESSORS column to capture any…
-
Duration and Date closed columns auto populate when Date initiated column is filled in
I have "Date Initiated", "Date Closed" and "Turnover Time" columns. The initiated and closed columns will (should) be populated when they happen, but the closed column auto populates to the same date as the date initiated column when it gets filled in. I also had to create a "Predecessor" column which I hid because I don't…
-
Smartsheet Gantt Chart
I’d like to suggest enhancing the Gantt chart to support more complex project schedules, similar to Microsoft Project Professional or Primavera P6. Currently, Smartsheet’s Gantt chart works well for simple schedules but is not suited for managing complex construction projects. Improving this feature would make Smartsheet a…