MichaelJameson

4 years agoQrew Trainee

# Scheduling Calendar

Has anyone figured out how to produce a good scheduling calendar? I have a table where I have production tasks for various departments with an associated time estimate for completion. I would like to make a calendar that will look at tasks (by dept) and also look at time estimated (if 16 hours, span 2 days) then append the subsequent tasks to the following days.

For example, if a department has three tasks;

task 1 - 16 hours

task 2 - 4 hours

task 3 - 20 hours

I would like task 1 to span Mon and Tues

task 2 to be only on Wed

and task 3 should span Wed Thurs and Fri

I already made a calendar view; but all of my tasks overlap each other - showing tasks exceeding a standard work day on any given day. I could resolve this by going into each task and manually setting a start / end date. But this solution seems quite tedious as I have hundreds of tasks. I am hoping to utilize a formula (maybe?) to make the calendar limit the number of tasks on any given day by the estimated work time. (ordering of tasks - take precedence by lower record ID)

------------------------------

Michael Jameson

------------------------------

For example, if a department has three tasks;

task 1 - 16 hours

task 2 - 4 hours

task 3 - 20 hours

I would like task 1 to span Mon and Tues

task 2 to be only on Wed

and task 3 should span Wed Thurs and Fri

I already made a calendar view; but all of my tasks overlap each other - showing tasks exceeding a standard work day on any given day. I could resolve this by going into each task and manually setting a start / end date. But this solution seems quite tedious as I have hundreds of tasks. I am hoping to utilize a formula (maybe?) to make the calendar limit the number of tasks on any given day by the estimated work time. (ordering of tasks - take precedence by lower record ID)

------------------------------

Michael Jameson

------------------------------