Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Creating dependancies so I can change my start date

Lorna Linehan
edited 12/09/19 in Archived 2017 Posts

I am setting up a project plan but at this time I am not sure what my start date is. I can set it up with a possible date and create my tasks and dependnacies. But how can I make sure my dependancies are set up correct so that when I change my start date everything will fall into place.



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    IF all of your rows contain dependencies, then you should be okay. The challenge exists if some are dependent and some are not. If you make sure every row is dependent (in some way or another) on each other, then you can adjust the first date and the rest will follow. Create your dependencies from the top-down if you want your start date to be the adjusting factor.  

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    To test, turn on Highlight Changes and set the Start Date. The start and end date columns should all change (I'd change to it something in 2018 to be sure).

    Alternatively, set the Start Date and save the sheet. Filter on the Modified column and 'is not today'. 

    If you don't have a Modified column yet, you can add it (it is a System column). The dates are stored even if you have haven't displayed the column before.

    Note that may be false positives due to Smartsheet's mishandling of the UTC time in some instances. Typically, this won't be a problem.


This discussion has been closed.