-
Cross Referencing Data Across Sheets
I've read several threads on this and tried to figure out solutions but am still stumped. I am creating a workspace for managing events. I have vendor lists with their rates and a planning sheet with the number of staff we need and which activities will be booked, etc. I'm trying to create an expense sheet where I can have…
-
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…