Extract top risks from risk log for highlight reporting

Hi there

I'm running a risk and issues log and need to pull out my top 5 risks and issues into a monthly highlight report. These are based on the original risk score and the score post mitigation(s).

Within my highlight report I have a number of cell links which pull through parts of the project plan but because the risks are an ever moving feast, I can't cell link these.

I have a report which pulls out the top 5 risks and issues but there's not an option to link back from a report.

I was wondering if there is a way to add a formula that could pull through specific data from another sheet based on certain criteria?

Thanks in advance

Phil

Find more posts tagged with

Formulas

Project Management

Cell linking

Comments

J. Craig Williams

Phil,

No, there isn't a way to directly reference a cell in another sheet.

What you couold try to do is have the reference go somewhere in the sheet (like row 1) and then point your cell link that cell.

I'm not sure that will work for your case. If you can post a screen shot, I might be able to offer more.

Craig