Cell Link or Formula for Start and Finish Dates
I'm looking to find a solution to populate the start and finish date columns based on info in another sheet. However, because I have dependancies turned on the date columns cannot use a vlookup or other function to pull the dates from another sheet where they are stored. Here is the basic setup:
Grid 1 includes dates significant to the project including a column for each of four "Build Waves" and the Start and End date for each. My hope was to populate those start and end dates once on this "Set up" grid when initially setting up the project in SmartSheet. Then I would have used Column Formulas to look-up and populate the Start and Stop dates for hundreds of line item tasks that are spread out over several additional sheets used by multiple teams.
Is there a way to go about this that I haven't considered? Your help is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!