Hi all,
I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated instead of manually inserted by the users. I know I can't use formulas on the duration column, so I tried using a workflow with a "change cell value" action to be executed every time someone creates or changes a row, but I can't select the duration column on the "change cell value" selection box. Does anyone know what the problem is, or at least what are the restrictions to which columns can be selected on that selection box? Or even if there's another way of automatically populating my duration column?
Thanks in advance.