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.
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…
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…
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…
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…
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…
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?
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?
Hello! I have sheet summary formulas that collect various metrics on my data. The sheet / sheet summary is updated every time we attach a file to it (which is at least once every business day). I would like to capture the sheet summary metrics at a specific time interval - maybe once per week - and add them to a new row on…
