Good afternoon Community, I'm working on a new summary sheet and have a 2 part question I need help on…Some background: I have a sheet to track our recruiting efforts and am working on a Summary Sheet I'll use to build a dashboard. PART 1 I need to count how many reqs are open each month. This would include any reqs that…
Not sure if this is possible - If there is a cell that has words and then a dollar amount, is there a formula that can be used to pull only the dollar amount into a report and then on the opposite side be able to pull the first part and not the $ amount? Ex: 11111 - Test Item - $100 The format for the example could…
Hi - I created a sheet summary report for 4 project. My Total At Risk column is coming back with the error #UNPARSEABLE even though I used the same formula for that column. Can someone give me some guidance on what I could do to troubleshoot the issue? Here is the Total At Risk column formula that I used for each sheet:…
Can the Sheet Summary Report be printed? I am looking for an easy way to print or PDF the report.
I have created a template for our PMO to use and a report based on the sheet summaries each sheet contains. Older projects have had the sheet summary fields added, rather than migrating existing projects to a new sheet based on the template. Something odd is happening - some fields are appearing twice in the column…
Hello, I am having a hard time setting up this formula in Sheet Summary =COUNTIF([Core Customer Name]:[Core Customer Name], "ISNOTBLANK" Can someone help?
I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase depending on which tasks have been complete. Once all tasks in a phase have been completed, the sheet will report back that…
We are using sheet summary to show how long each project is in each phase by using =duration1 (or whatever the line number is). My question is - is there a way to color code it a certain color if the phase is still in progress, or on hold, etc, but we have moved to a new phase and it then shows a certain color then in…
I have a sheet I want to move over to the gov version, and when I went to do that I noticed there is no sheet summary. My sheet has hundreds of formulas and it would be useless with out them. Any suggestions on where to put them? Do I make another column called sheet summary?
