-
COUNTIFS giving INVALID DATA TYPE
Hello, I am working on a Dashboard for a Program Plan and I am trying to get a read for the amount of items in a particular sheet that are past due that are not completed. These columns are identified by "Target End Date" and "Health". Target End Date is a date column. Health is a single select drop down with the options,…
-
COUNT(50) on an Empty Sheet
Not so much a problem as just a question on a weird occurrence. I have two sheets, one with a checkbox column formula [sheet1] and one with a summary row [sheet2]. I have a very simple reference on sheet2 that is =COUNT({sheet1 Range 1}), where {sheet1 Range 1} is checkbox:checkbox. For some reason, COUNT({sheet1 Range 1})…
-
Calculating 14 day due date
Hello, I'm attempting to collect training metrics by department and I'm unsure how to incorporate a formula to identify criteria for training due 14 days from today. The below formula references a report with a Due Date column, not sure sure how to create the criteria for due dates 14 days from today. Thank you in advance!
-
VLOOKUP with multiple criteria
I have a VLOOKUP formula referencing another sheet and it works great. The problem I run into is when I need the same formula to look up multiple criteria before returning a value. Current formula (works): =VLOOKUP(Date@row, {BYP RSS Links}, 7, false) I want everything in the formula to remain the same, except I want it to…
-
Index Match Function Not Working
Hi, I have an Index Match Function that is only working for some of the rows and coming up with a "NO MATCH"" for others. It doesnt make any sense to me as it is referencing Auto Numbers that are clear and easy to match. The formula is: =INDEX({Contact List Name}, MATCH([Company Index]@row, {Contact List Index}, 0)) Source…
-
Help to count a column where neither 'Complete' 'Canceled' checkboxes are selected
Hi all, I am trying to build a formula that references another sheet, mostly focusing on 3 columns in that sheet: At Risk (symbol) | Completed (checkbox) | Canceled (Checkbox) I am trying to count all the values in the At Risk column where neither Completed or Canceled checkboxes are selected. Basically, I'm trying to…
-
Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error. Formula that I am using is =COUNTIFS({Primary_Owner},…
-
Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days. For example: “Date” = 07/10/22 Today’s Date = 07/22/22 Is the “Date” within the range: 07/01/22 –…
-
Which count formula do I use?
Hi, I have two sheets. The first sheet changes daily the words passed or failed depending if the item passed or failed our process. On the second sheet I need a daily count of how many items pass and how many items failed. This sheet needs to updated daily depending on how many passed or failed their are. I've been reading…
-
Want to count number of instances in a column
HI There, I have one column in which I track the status of each row with a traffic light (Red, Yellow, Green). I would like to count the number of Red's, Yellow's and Green's in the column so I can use this information in a dashboard/portal to show the number of each color/status. I have triied a few things, but I am…
