All Dates populate based off one date



I am trying to create a sheet where I can put in one date in the Target Start Date column then all other dates populate from that date based off the duration it takes to do all the task. Is this possible?

Best Answer


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Dakota Haeffner

    I hope you're well and safe!

    Yes, you can use the Dependencies feature to make that work.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Dakota Haeffner
    Dakota Haeffner ✭✭✭✭✭

    @Andrée Starå , Would you be able to explain how I could do it with it as a child row? Basically, they want to base everything off the Class Start date (Row35). Basically, we want to start this class on 10/10/2022, now all the dates in the sheet need to mold around that date. So row 41 needs to happen 20 business days after that, however, row 23 needs to happen 10 business days before that.

    I tried adding the predecessor to the date start row but it's saying if I change the start date it will delete all predecessor dates. I want to make this a template the supervisors who will follow it can use where they plug in the date and now when everything must be done by.

    Any ideas?

  • Wilen FL
    Wilen FL ✭✭✭✭

    @Dakota Haeffner

    You may want to explore approaching this by using column formulas.

    Go to the Solution Center within your Smartsheet account and search Formula Handbook. This is a great resource to get you started.

    Formulas require a learning curve, but once working, right-click on the cell and select Convert to Column Formula at the bottom of the pop-up menu.

  • Dakota Haeffner
    Dakota Haeffner ✭✭✭✭✭

    @Wilen FL Thank you for the suggestion, but I don't know of any formulas that can do this. I'm pretty familiar with formula creation.

  • Dakota Haeffner
    Dakota Haeffner ✭✭✭✭✭
    Answer ✓

    Hey all,

    Figured this out using a negative (-) lag date in the predecessors field then made my first task a predecessor of the start date from that row.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!