Dependency Workaround: Linked End Date, Not Duration
I'm linking to someone's Start Date on a project, using the relevant sheet. However, the End Dates I need to track are at the end of a long set of tasks on another sheet - only once all those tasks are completed will this person's time on the project be done. I'd like to link to the very last task this person will perform and have Smartsheet do the math on how long they're working in total. I understand that I cannot currently link an "End Date" from one sheet to another, because the "value is determined by a project dependency." But I'd love the ability to shift the dependency from the End Date column to the Duration column, which is the column I need to auto calculate.
Is there a workaround for this issue? I saw in another forum post that someone mentioned creating another End Date column and linking it to there, but that doesn't solve the issue since the original End Date is blank, thus my duration is blank. Or do I need to disable dependencies, link my Start and End, and use a Duration Formula to calculate it?