Dates - Gantt Chart

I'm building out a plan with tasks and dependencies and want the dates to populate based off a vlookup. For example, If "Sprint 12" is selected then the proper start date is set in the Sprint Start Date column...which I am doing now with =VLOOKUP([Sprint Start]4, $[Sprint Start]$123:$[Sprint End Date]$136, 3, false). The problem, however, is that date will not populate the Gantt chart since that looks at the project Start Date and End Date columns. I don't want to have to manually set the start and end dates in those columns, I need to set them based off the Sprint number selected. Any help?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!