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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…