Adding a Timeline

Gaetano_B

Hi Wonderful People,

Could you kindly help me create columns E&F of the attached.

Col. E contains three milestones Completion, QC Submission and Business Connection.

Col. F shows an overview of the milestone status, which is based on the dates shown in col. B&C and D and indicates whether the milestone is overdue, due next 7 days etc.. with a view up to 45 days.

I know It's  quite a complex task, would someone be so kind to help?

Thanks in Advance,

Gaetano

Milestone.xlsx

OllieClarke

Hey @Gaetano_B I had a crack at this, but my answers are a bit different to yours

for instance this record only has 1 row in your dataset,

whereas my output looks like this:

Is there some other logic at work rather than just filtering out those milestones which are more than 45 days away (in either direction?)

I've attached my workflow so you can have a look anyways though.

overdue.yxmd