-
Join Ancestors help
I have a sheet that has a Task Name column which has Parent and Child rows. I have another column "Levels" that tells me the level that each row sits in the hierarchy. My formula does everything except include the data for task names that are at Level 4. I cannot figure out where I am going wrong. Any help is greatly…
-
Metrics Sheet Formula to Calculate Average of Numbers in Column on Main Sheet
Hi, I have a main sheet with the columns seen below. As stated in the notes, I have not accounted for skipping the calculations when a date missing in a row. That's my first request -- correcting the first 3 formulas. Second, I have a metrics sheet where I want to have a formula calculate the average of the numbers in the…
-
Running job to date hours on a project per task code?
How can I have a running total of Job hours to date per task code display on a sheet that shows actual hours vs estimated hours? The problem I am running into is: I have a weekly time sheet that is filled out for the employees on a particular project. The time has to be separated out by Straight Time, Over Time, Double…
-
easier references to other sheets
Hi all, I prefer to use references of the form {sheet_name Range 1} rather than using the "link from cell in other sheet..." because the formula can be copied to another cell where trying to copy the direct-linked cell only copies the value, not the link. If I have a lot of cells all linked to a particular cell in another…
-
Duplicate rank what formula would return the most recent week?
I have a formula to return the date of the 5 highest ranking weeks. Two weeks are both ranking as the 5th week as they both have the same result. Currently it is returning the oldest of the two dates. Is there a way to get the most recent week instead?
-
Add a number of months to a date
Hello I have a field "laste due date" which contains a date, I would like to add to this date a number of months defined in the column "FREQUENCY (month)" so that returns the date incremented in the column "TEST", I have several formulas without success, it's a pity that there is not an equivalent formula in excel with the…
-
Return values from a sheet
Hello, I have a sheet with the following columns: Recordable (yes/no) Date Description This sheet has a list of all injuries . . many line items. In a summary sheet I want to return the "Date" from the most recent line item where "Recordable" = "Yes". On a separate line on the summary sheet, I want to return the…
-
Remove formulas in data shuttle
Data shuttle does not allow formulas to be turned off so when I upload an excel file in data shuttle, my numbers are being rounded.
-
Sumifs with criterion range in column with multiple entry options
I track all of our projects on a single sheet, to include opportunities and finished projects. I want to sum the total sold amount. I have a column called "project status" that has 11 options for various status descriptions (i.e. pipeline, proposed, awarded, booked, complete, etc.). I'm trying to use this column as the…
-
Counting rows from another sheet that meet a specific criteria
Hi All! I'm trying to count the amount of rows from another sheet that meet the following criteria: All rows that are within the "Quality Control - Bioassay" department, that are not closed nor cancelled in the status column and the creation date is less than 30 days, then less than 60 days and then more than 90 days…