How to avoid duplicate entries in a report due to linked cells in multiple sheets

c_berg

I am close to creating a calendar (report that only shows activities across sheets with duration < 15d), but have run into an issue where certain activities or milestones are showing up twice because they are linked between sheets. Other than manually identifying these linked cells (checkbox, etc), any ideas for a more automatic work around or another approach?

Apologies if this has been posted anywhere else - Thanks!

J. Craig Williams

c_berg,

There is no Report Builder

1. "no duplicates" feature

2. "no cell linked info" feature

I can not think of a way to automate the duplicates away without one of those.

Craig