-
Overall Health Symbols at Parent Level
Good Morning, I am trying to add health symbols that will tell me the overall health of my project as well as the individual phases withing said project. Below is currently what I have at my children level for health symbol formula. Children Formula for Health Symbol: =IF(COUNT(CHILDREN(Tasks@row)) = 0,…
-
Best Practices for Copying Multiple Sheets
I have about 10 source sheets that I need to copy to a new sheet. They have most of the same columns, and they are tracking the same type of information for different projects. I've attempted to merge them onto one report, but there are duplicate columns (and nearly 1,700 rows), and I don't know how to unify things so the…
-
I have a drop down for Objective based on selection I would then like to auto populate KPI
I have a drop down for Objective based on selection I would then like to auto populate a drop down field in the KPI formula. I don't think an if statement will work as the KPI drop down is a multi select - one objective can have 4 KPI's. I tried adding logic but it does not go deep enough, or I am doing it incorrectly.
-
Automation Workflow Asssistance - Trigger based off Task's due date
Hello, Is there a way to sent an automation reminder to be triggered on my project plan for a task when another task's due date is 3 weeks out. For example, I have task A, task B and task C. Task B and Task C need to be completed before Task A can be completed. I am wanting to create an automation to notify the assignee…
-
How to obtain most recent date a row/task was modified by a person (versus system or formula)
Hi, I am trying to see/report if the project manager and/or task leads are updating their task status on a weekly basis. They use Dynamic View to do this. I currently capture a date using the MAX (modified date: modified date) function in the sheet summary but this date also includes updates triggered by formulas (e.g.…
-
Linking my pacing sheet to a dashboard - if the date column is Today, return the total hours for the
Hello, I am trying to set up metrics for a lab testing schedule. I have created a pacing sheet which is set up to show how many hours of testing each analyst is assigned that day. The left column is the date, and the column next to it is the total hours assigned for the day. I would like my dashboard to show the total…
-
Dashboard Update Automatically Daily
Hello, I'm having issues with a dashboard I have set up, not updating information from a sheet until that sheet is opened/refreshed. I currently have a sheet with rows of names and corresponding dates; basically, shift schedules by day. I then pull whatever names correspond to today's date into a sheet summary and have a…
-
Using sheet reference to build placeholder text for an email alert
Hi I am attempting to build placeholder text for an email alert but I want to do it on another sheet referencing the data on my master sheet. It will include text and cell references. Basically I'm trying to write something like the following. "Hi name, Cardholder has made a purchase at Vendor for $XX.XX. Please review and…
-
Need a Formula to Count repeated values in both cells
Here India and US are repeated in both cells, hence I need the value 2 via formula. Kindly help.
-
#UNPARSEABLE when using Cross Reference
I am trying to "simply" use data from one sheet and if the cell is Yes, it then adds another Cross Reference to the new sheet. If (Cross Reference: Refile Access) is Yes, then (Cross Reference: User Name). If Cross Reference: Refile Access is no, then nothing would happen. Both cross references appears as being used so I…