Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
It would be great to reference another row dynamically by using the value in another column. For example, I would love to be able to reference the values of a column in a predecessor row using the predecessor column value. I would love to be able to use a formula like: =[Actual Finish Date]@row - [Actual Finish…
September 16, 2025 We recently expanded dependency management in table view. In addition to editing task start and end dates, users can now define and manage predecessors directly in the sheet, making it easier to keep project schedules accurate and aligned. Predecessors let you link tasks so that dependent dates…
Hello, The SmartSheet seems to be locked with predecessors dependencies not updating start date of activities. Also the duration does not seem to update the end date. So all needs to be done manually. This was working last week but seems deactivated. How can I reactivate it? Thanks
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…
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…
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…
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…
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…
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…
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…
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…
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…
It looks like you're new here. Sign in to post and engage.