-
Better Sorting for Sheet Summary Report
If you have several dates listed in the sheet summary on a project, then you can have an option for those to be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of…
-
Sheet Summary/Sheet Summary Reports Questions
Hi, Is it possible that if you have several dates listed in the sheet summary on a project, that those can be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of dates…
-
Formula to Summarize spending each week to display in a Dashboard
Hello, I have a large sheet that we use for procurement for our company. Employees use a form to requisition items, and then when I place the order for them I input the date ordered into a column. Another column tracks the cost of each order. I would like to have a formula that uses the "Ordered Date" column to add up the…
-
Ranking by score
Hello, I have a sheet that contains people and scores (1-100) based on their performance. I want to create a table to show the top 10 and the bottom 10 people based on their score. Any ideas on how to do that? Regards,
-
option is not blank + assigned to
I'm trying to count the number of cells in a column "CPS Has Referred Member To:" that are not blank, by individuals identified in "Assigned To" in a sheet summary
-
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
-
Cell linking a sheet to a summary field in another sheet
Does anybody know if there's a way to cross-sheet cell link (1 sheet to another sheet) to a field defined in the summary section of a sheet? I looked everywhere in the "link from other sheet" pop up screen and couldn't find anything. Thanks, Rich
-
Sheet Summary best practice - request for guidance
Hi, I have a sheet summary that is calculating the same values over and over for different categories - a total and progress counts for Fred, Wilma, Barney and Betty. What's the optimal way to do this? Should I create all values in a single sheet summary or can I create multiple summaries for the same sheet, each focused…
-
Cell Linking User Distro List from one Sheet to another Sheet Summary for Copy and Pasting
Hello, I have a user column contact list with user emails in one sheet (1) and two additional columns for different distro lists that each user is a part of. I am linking these columns/cells to a project roadmap sheet (2). As part of Sheet 2, I am utilizing the sheet summary and I have added fields within the sheet summary…
-
Column functionality breaks when copying sheet
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…
