-
Should a non-licensed user that is shared as an admin be able to see and use Work Insights?
I am a licensed Enterprise user and have added some Work Insights to my sheets. The sheet is shared to a non-licensed user as an admin. They are not able to see the Work Insights button on the right of the sheet or see the summaries in the sheet. What do they need to do to be able to see the Work Insights? Are only…
-
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…