-
COUNTIFS based on conditions
Hi I'm trying to count the number of teachers from different cohorts that have not yet given feedback through a form, so the cells with #NO MATCH. I have all of the data in 1 SS and am totally and running metrics in another. In the sheet I'm running the metrics in I have a row for each cohort, and where I want the count to…
-
Index Match only returning first index option?
Hi, The Goal: Use index match to return a column name based on which column in a given range has the maximum value of that range. The problem: I can only get 1/5 of my return options to work, and only when I add 1 as 'column index' field to the Index formula (usually column index is optional- I've never needed it in any…
-
Formula Help!
I'm creating a dashboard that contains some metrics. I have my metric worksheet already setup and have pulled over info. I'm needing a particular formula and cannot seem to figure it out. Here is what I'm working with: I need to search one column of information for any input values for only the past two weeks IF a…
-
COUNTIFS and Date Range
Hi I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count. For this count I want to filter on current date date from a range in a column (Current Due Date). e.g. date range 30/04/2019 to 30/04/2020 =COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2,…
-
COMPARE COLUMNS
Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column. What kind of formula de you recomend to do this? I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1; false) and Match; =MATCH([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1) But i only…
-
Intersecting Contacts and linked data
Hi there, thanks for all the contributions here - I already have solved so many issues. I'm stuck on one and hoping someone can think of a workaround: In one row I have multiple contacts assigned in a contact type and I want to highlight the cell that intersects with another column. In this instance, its because I need…
-
repeat sum IF for mulitple cells
I have column "Location".. then many rows of citifies with lots of data for each city. I need to summarize my data "By Question" AND "Location" - however it does not work to "drag" or to copy paste. I have to change all my information in every cell... I have hundreds. Is there an easy way? In Excel, I could drag and it…
-
Auto fill cell value if adjacent cell matches cell in another sheet.
Hello, I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on my main RFI Log. my main log: 1st column is RFI #, and 2nd column is internal…
-
Formulas for Column Dates to Autofill
Hello there, I have a sheet setup with 4 columns of dated. Project Owner Completion Deadline, Project Owner Actual Completion Deadline, Project Auditor Completion Deadline, and Project Auditor Actual Completion Deadline. I am trying to figure out how to set it up so that the Project Auditor Completion Deadline will auto…
-
Don't include parent rows in checkbox complete roll-up percentage
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that should not be included in this total. I had a formula that sort of…