Looking for a solution to Gantt style planning but backwards from due date

Helene

I'm a transcriptionist and I have multiple transcriptions at a time in my to do pile. These all have due dates and I have a good idea of how long it would take to type them up. Ex, due March 1st need 3 days to type, must start by march 26th. If I have multiples due on March 1st, I can't start them all at the same time so they need to also be conditional. In a Gantt chart I can also input days off.

My biggest question is, in excel I can make a table that calculates the start by date when I input the due date, but this doesnt take into consideration days off, and other transcriptions due around the same time. A Gantt chart shows me how everything flows on a calendar. 

Does anyone have any suggestions for how to do this

Helene

I have an excel sheet that shows the data I need to track as well as the calculations I use.

If anyone can help, I would greatly appreciate it.

Andrée Starå

Hi Helene,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Christine Rosenberg

Hi Andre

I have a similar issue as Helene.

IE. I have a meeting date, and I want to create a workflow for the documentation used in the meeting:

Meeting date: 1st of May

send material to meeting members: Lag 4 days

approval of presentations by chairman: 3 days

revision of material by PA: 2 days

8X materials from 8 different people: duration 5 days.

Question .can I set the dependencies and the final due date (meeting date) and have smartsheet calcutae/populate the cells with date, so that I can see, when the 8 people should start working on their materials?

Andrée Starå

Hi @Christine Rosenberg

I missed your post. Have you solved it or do you still need help?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Christine Rosenberg

hi @Andrée Starå

still an issue. From what I can find in the solution center and in the community is, that the only solution is to remove dependencies?

Best

Christine

Andrée Starå

@Christine Rosenberg I think we can set it up with dependencies enabled.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)