-
How to check if Flag has been flagged in another sheet? Formula?
I have a metadata sheet that has At Risk row with a flag symbol, and I would like to check the other project sheet with an At risk column to see if any flag has been marked in that column. If any task has been marked in the project sheet, I would like the flag symbol in Metadata to turn red as well.
-
Where am I going wrong in this SUMIF formula?
Here is my formula: =SUMIF({Shell Projects - High Level Tracker CP}, Wholesaler@row, {Shell Projects - High Level Tracker Owner}) I'm trying to say, if the "Owner" on another sheet equals the Wholesaler on the row on my sheet, then sum the CP on that other sheet. The formula isn't throwing any errors, but is return an…
-
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 –…
