The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work...
I am using a standard sheet template which I also use to forecast,
I would like to change the 'duration' of a set of tasks based on a dropdown that would return 'Small', 'Medium' and 'Large' so that I can maintain one template.
It would seem that I cannot put a formula inside the duration column... is there a formula that I could use that could add / update / insert the correct duration based on the condition found in the dropdown?