Gantt View - Settings requests

Hi,

I'm trying to create a dynamic 'To-Do' list (for want of a better phrase), that automatically steps the jobs - i.e. only start task 2 when task 1 is expected to complete.

I want to make this as automated as possible, and I understand that dependancy columns do not accept formulas, but wanted to know if there was another way of resolving this.

All tasks would preferrably auto-fill with a 5 day duration, starting when the previous task is expected to be completed.

Sorry if I'm not being clear, I'm new to raising threads on Community - any feedback would be amazing

Find more posts tagged with

Manufacturing

Formulas

Product Development

Gantt View

Project Management

Comments

Paul Newcome

To do this without using the dependency settings, there are a few different ways to establish predecessors.

Will the tasks be listed in order where Task 1 is on row 1, Task 2 is on row 2, and Task 1 must be completed before Task 2, Task 2 before Task 3, etc?

Will the different tasks be in a random order on the sheet?

How are new tasks added?

How are tasks marked as completed?

Are you able to provide some screenshots with some "dummy data" to show what you currently have as well as what you are hoping to accomplish?

Antony Dowell

Hi Paul,

Thanks for your feedback!

I currently do not really have anything set up, this plan will be used within our Engineering Team to advertise their projected 'lead time'.

The tasks will be entered in order, to try and accommodate a FIFO (first in first out) ruling, but once task 1 is complete, task 2's time required needs to start from the date task 1 was completed..

What we are aiming for might be a little bit too 'fluid', but not too sure...

I would include screenshots, but as I have nothing created yet I wouldn't know what to include.

Thanks again

Paul Newcome

This is actually a pretty straightforward solution. If you would like to share your email, I can share a sheet to you. It will be much easier to explain with visual examples what exactly is going on within the sheet.

Antony Dowell

That's great Paul, adowell@brucom.co.uk

Many thanks

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…
Prevent due dates from falling within the same calendar week?
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…