-
Project Plan Reports
Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a different task that is the oldest incomplete task. Is this possible? If not, is there a formula that pulls the task name that I can…
-
Formula on Project Plan
Hi, I have five stages on a project plan, parent row s, with numerous child tasks underneath. I want to have a formula that marks child tasks based on this formula: =IF([% Complete]@row = "1", "ITEM COMPLETE", IF([% Complete]@row = "0", "ITEM NOT STARTED", "ITEM IN PROCESS")) The parent rows also have this formula: =IF([%…
-
Insert todays date on a project plan start date column
Hi, I use blueprint control center to replicate the templated project plan for every project that we approve. I want to automate the start of this project plan by entering the date it was created as the initial starting date for the first task. My plan is full of predecessors, so once the initial date is inserted in the…
-
Project Management
We have 4 employees that receive daily projects assigned to them. To avoid having the employees viewing their co-workers daily schedule by sharing the project management sheet and doing a filter so they only view their daily projects but can also turn off the filter as they please to see the complete project management…
-
Formula for Hours Scheduled by Month
We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without the EOM function. Can someone please help?
-
Attachments & Proofing
Hello, To proof I have to first upload a file, but what if the file had already been attached to the row; is there a way that an attached file can be automatically moved into proofing. Thanks
-
How can I change the Card View to show a different column?
Currently my Card View is showing my "Status" column and I would like to change it to the "Assigned to" column.
-
Conditional formatting
Hello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?
-
Mapping data within a hierarchy
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this date in the parent cell of this hierarchy, regardless of whether new rows are added during the project's development. The…
-
Resizing the Image Widget
Is there capability to adjust the white space around the image, in the Image widget on a dashboard? When I insert a logo, there is a good amount of white space bordering the image, and therefore takes up much more room that it needs to on the dashboard.
