-
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?
-
Is it possible to set up a data shuttle from a sheet summary?
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…
-
Creating charts with multiple criteria without summary sheets and thousands of distinct formulas
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 Expert. There are additional columns for each employee's name, department, and whether they are 'Active'. In order to create a…
-
How to create a chart of the sums of sheet summary fields from 2 different sheets?
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 can even sum them up. What I cannot seem to be able to do though is create a chart based on the total row. Can anyone…