Duration and Predecessors: What to do when you have 1000s of rows?
I have a sheet that contains original data as well as data imported from CSV files. We have a template that we use to copy the CSV data from different external sources.
This template contains pre-built tasks and milestones, like this:
The dates come in as TBD and the hierarchy is flat (no parent and child rows). In the screenshot above, all the lines are from the same project. A project could have 20-40 separate tasks. The sheet has multiple projects and contains more than 7,000 rows.
How would I enable dependencies and predecessors without having to touch each of the 7,000+ rows? How can I work around so many of the Task Start Date and Task End Date fields not being a date value?
Also, would I need to assign hierarchy to the rows for the dependencies and predecessors to work? I could add a helper column, Hierarchy, labeling rows with an A, B, C, or D hierarchy if that's needed.