All Dates populate based off one date

Dakota Haeffner

Hello,

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?

Dakota Haeffner

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.

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!

Best,

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!

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

@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

@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

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.