Linking Formulas to Reports

Mathias Kjeldsen

I am currently working on pulling engagements/deliverables and other important information from all my projects into one consolidated program level dashboard.

An example of what I came across, I can create a report where I pull all the tasks at risk across my project schedules and it is very easy to add a schedule to the report when a new project comes along. However, I cannot pull the count of rows from this report. Currently, what have on shown my dashboard the list of tasks at risk, however, I would also like to show a count on the side.

Right now I understand the way to do it is writing a formula in a sheet where I reference each schedule and count the tasks at risk. For simplicity and for team members not familiar with formulas, adding a new schedule to the report is much easier than having to modify the formula.

Is the formula currently the easiest way to do this, and is there no way to count the number of rows in a report?

Paul Newcome

The only way to get a count of rows in a report is to use the built in grouping and summary features within the report.

Formulas cannot reference a report, so using a formula means creating new cross sheet references for each schedule.

If you are using Control Center to deploy your schedules, you can use that to automatically link pertinent project information from each project into a Summary sheet which could then be referenced via formulas.