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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!