-
COUNTIF Formula Error in Sheet Summary
Hello, Trying to use an existing formula in our sheet summary that is working for another column (dropdown list) in sheet summary. Not sure why it's not picking up the count for some columns and not others. The forumula's look the same and I've replace the column and cell names. Getting back 'unparseable' error. I've…
-
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…
