Sheet Summary
Discussion List
- I'm trying to have the Sheet Summary list the employee name from the Repeat Category Winner column with the highest Repeat Count per Category, and I have 3 categories that I will use this for (Timeshe…
- Hello! I am trying to manipulate a formula in my sheet summary to return a percentage complete based on the value selected in the dropdown menu I created. The formula I've tried (and a few variations …
- I'm really struggling with countifs in my Sheet Summary. I added a helper column to sparse the month. I want to count if the created date is February, and if two columns containing IDs are not blank. …
- Hello, I have a formula set to count how many projects are flagged within a specific function if they are listed as in progress, but the count is off and I can't figure out why it's not counting all i…
- I'm working with Control Center for the first time and setting up a blueprint. My project templates are pretty straightforward - project plan, RAID log, reports, dashboard, etc. I have a portfolio lis…
- I use the summary sheet extensively for allowing project managers to provide high level summary reports on their projects. My c-suit would like to be able to see status report history. In absence of p…
- I'm using Sheet Summaries to total up information in a large sheet. This sheet also uses formulas to pull information from other sheets. I receive a #NO MATCH error when attempting to use a COUNTIF fo…
- Hello, I am expecting this formula to count the number of cells in the "FND Prepare" column that have a certain name in them, where the cell on the same row in "Prepare Status" is not green. =COUNTIFS…
- Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to re…
- Current Formula is for # Enrolled =COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course") I need a formula for Enrolled AND # Late Status Red X