Sign in to join the conversation:
Is there a way to create dependencies between multiple sheets in a report.
can you provide more details about what you are trying to do?
Hi...I have the same question...
I typically manage or consult on multiple interdependent projects. I've tried managing dependencies across projects in different ways but none of them have been super successful.
For example, Project A - call it Telephone installation - has a dependency on Project B - call it, Network Infrastructure upgrade. They are being managed as two separate workstreams because of their content and resources, but at some point, work on project A will stop if Project B hasn't reached a certain point (usually a milestone).
I would like to (in the best case) show the dependency actually in the dependent project so that Project B is late, the remaining tasks of Project A slip. Alternate would be okay if I could just report on the dependencies and highlight pending problems.
Any suggestions would be appreciated...
Rob
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
