Hi There,
I am using my smartsheet to manage a production of furniture goods. I have set columns up for Start/ Finish/ Expected finish/ Duration/ and Delay to Expected finish. This will enable me to see where the delays are happening in the process and analyse where to improve.
I have set the dependency between the Expected finish and Finish to give me the Delay to Expected finish. However I have noticed that this gives me the same figure, whether the Finish date comes before or after the Expected Finish date. I.e. a process finishes early or late.
Is there a way of setting the dependency so its illustrates this? I.e. If a task came in one day early it might read, -1d, or if it came in a day late, +1d?
Thanks in advance,
E.winter