Task end date as a function of resource availability

edited 12/09/19 in Smartsheet Basics

Hi community,


I'm seeking to calculate a task end date as a function of resource availability.

Say a task completion depend on a resource availability and productivity. How can I calcualte a task end date given a resource availability.


Here's a simple example to illustrate :

Task : Writing a 1000 pages documents

The task is assigned to a writer with a 10 pages per day productity.


How can I calculate the task end date, taking into account any period of the resource will not be dedicated to his/her task. (holidays, training etc.).


I hope that is clear. Best.