So I want to populate Duration from another cell on the same sheet.
I get that Duration is auto-calculated from the start and end dates, AND that I can manually enter a duration to adjust the start and end dates. HOWEVER, I have already calculated the number of days that a task will take. So I want to have that number AUTOMATICALLY appear in the Duration column, OR have the End Date automatically calculate based on my task days.
How can I accomplish this? As is stands now, I have to manually enter the days into the Duration column. No bueno.