Discussions - Smartsheet Community

Browse Member Tips

HOW TO: Duplicate / Copy a Group
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…
Formula to add Months to Date
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),…
Pre-Filled Forms Using URL Queries: Tips and Tricks
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…

See all

Recent Discussions

Actual Dates Update Dependent Activities' Primary Dates
So, we track 3 sets of dates - Baseline Start/End, Planned Start/End (our primary dates in the project settings for dependencies), and Actual Start/End. Here's the example: Activity 2 is dependent on Activity 1. The planned dates, planned duration, and Predecessor columns are all tied together, nice and happy. Activity 1…
Enhanced predecessor cell editing for dependency management in table view
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…
Dependencies not updating the activities
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
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…
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…
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…
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…
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…
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…
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…

Welcome!

It looks like you're new here. Sign in to post and engage.