Skip to main content
Question

Scheduling Calendar

  • September 29, 2021
  • 0 replies
  • 113 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
It sounds like you were saying that there are task dependencies, And that task 2 cannot start until task 1 is completed. That would involve use Predecessors.  https://help.quickbase.com/user-assistance/about_dependencies.html 

In practice these are somewhat of a pain to set up unless you have a standard set of tasks which you can copy into a new project which already has the dependencies established. Then the copy master detail function does a magnificent job of this. The whole concept of predecessors is a skill area to be acquired.  You might want some one on one assistance after reading up on it.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------