-
Finding Distinct Values in Two Columns
Hi, I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead. Is there a reason that I am getting 1 as my output here? Is there any other way I can accomplish this?
-
Referencing 2 ranges in another sheet
Hi all, I'm trying to use data from another sheet to get a count. I have 2 relevant columns in the reference sheet, Name and Date. I'm trying to count the number of dates for a given name in the last 30 days. Here's the formula I'm trying to use: =COUNTIF({Hiring Actuals Range 1}, ="Smith, John", {Hiring Actuals Range 2},…
-
How may I extract only the numbers from a cell?
I need to extract 16 and 9. As you can see the number characthers may change (I may have 1-2 digits) but always at the beginning. Thanks
-
Using reports
I have a sheet that is updated daily. I am trying to create a report that shows the previous 7 days worth of entries. I could not figure out how to do this so I created a helper column that checks a box for items that have a date up to 7 days prior to TODAY. However, if I don't do into the main sheet every day and save,…
-
SUM Formula Does not work with Quarter Formula
This is my test sheet. I have the following formula in Quarter column: =IFERROR(IF(MONTH([Contract Acceptance Date]@row) <= 3, "1", IF(MONTH([Contract Acceptance Date]@row) <= 6, "2", IF(MONTH([Contract Acceptance Date]@row) <= 9, "3", "4"))), "") The above works fine. I want to summarize sales by the 3rd quarter, so I…
-
Lookup and Return newest Date
Hi there, looking for assistance i am trying to create a formula I want to reference a second Sheet called "Medical/Lost Time" Id like it to look up the Shift entered in the Shift column and return the newest Date from the Injury Date column I've created a Data Sheet with the Reference names for the shifts ([Primary…
-
Cross Referencing with IF(AND
Hi, I am simply trying to grab data from one sheet and add to another. I've done this many times before but can't seem to get this one to work. I just want to populate the first sheet below with data from the second. For example, the number for Woodland on a Monday is 68. I have tried multiple IF(AND formulas which is not…
-
COUNTIFS incorrectly counting number of times a contact appears in Assigned To column
I am trying to track the number of tasks each employee is assigned to. In my Assigned To column, some cells have one contact assigned to a task and others multiple contacts. I am currently using the following function: =COUNTIFS([Assigned To]:[Assigned To], "John Smith", [Status]:[Status], <>"Complete") The function…
-
Count Parent rows and rows without children
Hello, We have an archive sheet where all completed projects are automatically migrated via "move row" workflow. Some projects have multiple child rows while some do not have any. I would need a formula to count a total number of completed projects regardless if they have or do not have child rows. If they have child rows,…
-
formula
Hi Guys I am needing help with another formula, in another sheet I want to extract data from the sheet above I want to get an average of days (green Highlighted amounts) is IF DEPT contains REF what is the average of Green Highlighted amounts) and the same for NIS and SSS