-
Rolling up counts from several sheets to a dashboard
I have 6 projects. Each has a risk register on a separate sheet Each risk has one of 5 possible statuses each of which has a color, (Blue, red, green…). Each risk also has a Probability/Impact score, grouped by 5s, 1-25 I have created 10 sheet summary fields on each sheet to count these. I have created a sheet summary…
-
Ability to add Sheet Summary Reports to Dynamic Scoping on Control Center
This functionality is available for "Row" reports, but "Summary" reports really should be included. Many clients use sheet summary to keep grids clean and lean; but, if we can't leverage dynamic scoping for those type of reports, it weakens the case for Control Center. It's either we bulk sheets up with columns to fully…
-
Rearrange Sheet Summary Fields - click and drag
Moving summary fields one position at a time is cumbersome and unnecessary. Please add functionality to those fields to allow a user to re-arrange and/or sort as desired.
-
GenerativeAI Help Creating Sheet Summary Metrics
Sometimes when making complex dashboards and scorecards, we have to create sometimes a hundred or more metrics on a particular sheet's summary. It would be awesome if the GenAI features could help you at least create the fields in the sheet summary. I am OK to adjust the formula as required, but the most time consuming…
-
Project Status to Update a Sheet Summary Status - Formula?
Is there a way to have a formula in a row or in the sheet summary that does the following: When a row is added in one sheet and the project status is Completed, then within the project itself in Sheet Summary change the status to Completed as well? I am not sure if it is possible as one status in one sheet would have to…
-
Blueprint SheetSummary Formulas
In the Blueprint project plan, there are Sheet Summary formulas, providing the 'Category' & 'Initiative' from the Project Metadata sheet. See below: =({Project Metadata | Category}) =({Project Metadata | Initiative}) I need to add a new SheetSummary formula in the blueprint project plan to pull in the 'Workstream' from the…
-
Count when 2 Conditions are met
I have a field called Status & a field call Health (using RYG symbols) This =COUNTIF(Health:Health,"Green") counts the symbols correctly. But I am trying to count Status "Open" that have a Health "Green". So I tried using COUNTIFS… =COUNTIFS([Health:Health],"Green",[Status:Status],”Open”) Gives #UNPARSEABLE 😕 Can anyone…
-
Sheet Summary - Why is the "Next" Button not showing up
Hi all - This may be a silly question, but I am trying to create a sheet summary report and when I go to select my source sheets the "Next" button isn't showing up (even when I scroll all the way down). I've attached a screenshot below. Has this happened to anyone else? Whatever help can be provided would be greatly…
-
How to center data in columns on report for dashboard
I have a sheet summary report for all my projects high level overview. I have the report on a dashboard. Its really bugging me the data is not centered on the report and subsequently the dashboard - how do I fix this?
-
Dashboard Last Updated Date
I would like to display the last time the dashboard was updated. My approach was adding a date field in the summary data that automatically pulls the last saved date of the sheet. I don't think I can do a formula in the date field type. Any other suggestions?
