-
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…
-
Formula to be copied and increment the column reference
Allowing a formula that references another sheet, and to be copied via the drag function to copy this formula in column "Rating 1" =IFERROR(INDEX({Rating_Avg_Selection}, 2), "No Data") in the same row to the right (next column), and reference the next number within the formula, which will point to the correct row where the…
-
Formula for calculating the Monday before a date?
Hi all! I'm trying to create a formula that will auto-populate due dates in a tracker that we have for new hires. In one location, their paperwork must be complete by the Monday before their start date. In another location, it must be complete by the Wednesday before their start date. They may start on different days of…
-
how can I add on the roll up table my contact list of mangers so that the formula work
i have tried adding the email - the name but it doesn't work ! this is the formula I have used and referenced the assigned to and status column
-
Project Status Formula Help
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column Hierarchy=0. The objective of the formula is as follows: If the Project Override field (in the Sheet Summary) is filled out…