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 Metadat…
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 "Gre…
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 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 - h…
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 …
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 woul…
I have a grid that contains an employee's level of expertise is a specific skill. There are 90 skills listed (columns) and around 50 employees. Each cell contains None, Beginner, Intermediate, or Expe…
I have 2 projects with sheet summary fields summing up the number of activities in different statuses (eg not started, in progress, completed). With a report I was able to pull this data together - I …
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse enginee…