cell linking for milestones

Ginny A.

I have created a sheet for roll up of select rows only for sight using cell linking. I can't seem to get milestone icon. What appears as Milestone icon on regular sheet has come over to cell linked sheet as regular task. How do I get the milestone icon on the cell linked sheet? 

Shaine Greenwood

Hello Ginny,

 

Milestones are created when a task is set to 0 duration. Your cell links are likely bringing over the Start Date value, which will create a default, single day task. You'll need to change the duration from 1 day to 0 in order to see the milestone.

 

One caveat to this: the duration can't automatically be changed, or cell linked from your source sheet—you'll need to manually change the duration to 0 on the destination sheet to get the effect you want.