I have a project request sheet that I want to record the dates when the row moves to the next status. I do not want to create additional columns in the original sheet. What I have done so far is creat…
Hello! I have a report that summarizes deliverables from several sheets, with the information displayed in a Gantt view. On the Gantt Timescale Settings, the checkbox to open the view to today's date …
I am in the PMO for a large engineering organization. Currently we have a large portfolio sheet (Control Center Summary sheet) that captures all of the information about each project. In our quarterly…
In one of my blueprints, all of the sheets have a "Navigation" section that helps users navigate to other sheets created: In the template sheets, these are just hyperlinks to the other templates. When…
I have been asked to provide a quarterly calendar view that shows all the projects being worked on in the upcoming quarter. They specifically asked to see all the projects grouped by their Business Pr…
Apologies if the title wasn't helpful - wasn't sure how to better summarize the problem. I have two columns - Payment Terms (Dropdown) and Invoice Date (Date). The Payment Terms column is either numbe…
I am putting together two sets of formulas so I can capture the number of tasks within a certain year and month, and another set to see which of those are completed. My formula that works to capture t…
Hello everyone, I have a sheet that summarizes the data across our portfolio. There are three columns I want to use in my COUNTIFS function: Core Assignment, SLT Flag, Status. I want to count all the …
Hello, In my calendar app, I have a main group and then a secondary grouping: With the grouping it automatically sorted the Features alphabetically. I would like the information to NOT be sorted alpha…
Hello all, I was asked to delete a specific column in the CRAID Log template and all instances created through Control Center. In my Blueprint, I have a sheet that is used to store some meta data that…