0

I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet.  We use these set as a template to save an copy to a new workspace or folder for each project.

I am hoping there is a way to make the project/sheet links stay

1

Hi all - I cannot figure out what's going wrong here.

 

I'm trying to count rows in another sheet ("Sheet A") where both the following are true:

  • Done = 0
  • IsChild = 0

My formula is: 

  • =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0)

 

Now this works perfectly!

 

So in a cell right below that

5

I am pulling data from multiple cells within a Project Sheet. The issue is that for each cell, the information is being presented differently. In some cells, the data is presented BELOW the Cell Title while in other cells, the data is presented NEXT TO the Cell Title. Is there a way to have the data