-
Formula to find how many requests a contact is assigned to
I have a sheet that tracks requests that come through a form. Each request then has a set of tasks that 3 teams need to complete. Within each request, there is 1-4 tasks that a contact can be assigned to. What formula can I use to show how many requests someone is assigned to? Right now I'm using a COUNTIF formula, but it…
-
How to show next occurrence? (Dates, Recurring meetings)
Hi all, It's early in the morning and I can't get my brain to figure this out. I have a number of different recurring meetings and I would like to generate a report that shows the next upcoming occurrence of each. So let's say data looks like this: I would like to generate a report that shows me something like: Board…
-
Need assistance with collecting and then joining
Hello, I have a test master grid sheet where dates of leave (and different types of leave) are collected through a form. Formula used for collecting dates together is: =IF([End Date]@row <= [Start Date]@row, [Start Date]@row + "", JOIN([Start Date]@row:[End Date]@row, " - ")) I have a 2nd sheet from which I want to collect…
-
Using countifs formula
Hello, I have used the COUNTIFS formula successfully in the past when pulling the status and date off a workspace. An example of the formula used is below: =COUNTIFS({Corrigo Work Orders Range 1}, "Closed", {Corrigo Work Orders Range 2}, AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30))) However, I now need to be…
-
Formula to Return Modified Date When Dropdown is Selected
Good afternoon, I'm trying to write a formula on one sheet (METRICS 1 - M&O Ingrants) that will record the modified date when a dropdown is selected in another sheet (M&O Ingrants). I want to do this so I can track the duration it takes to move from one dropdown selection to another because it's tracking status of a…
-
COUNTIFS with a date range formula is NOT working
Here is my Formula " =COUNTIFS({Master 8/1 - NTX/OK Volume Bid Fiber Based Range 3},">="&"03/21/2020",{Master 8/1 - NTX/OK Volume Bid Fiber Based Range 3},"<="&"03/27/2020")". please advise?
-
COUNTIFS #INVALID REF appear after a period of time
Hello, Able to get the countifs to total up some information in a different sheet. But then after a period of time, some of the cells using the countifs display #INVALID REF when it worked when I created my sheet screen shot shows a portion of my sheet, all cells use countifs and all cells did count what I wanted it too.…
-
I have Invalid ref with this code
=COUNTIFS({Generic - Parent Row}, 0, {Generic - NA}, 0, {Generic - Status}, <>"Blue", {Generic - % Complete}, <>1, {Generic - Task Name}, <>" ", {Generic - Task State}, <>"On Hold", {Generic - Finish Date}, <$Date$1) I have a metadata sheet that has everything in it. I dont know much about it but I am looking for start…
-
Formula that returns true/false if today's date falls between two dates on my sheet?
I am trying to write a formula that returns true/false when today's date falls between a date range on my sheet. I want the formula to return "true" if today's date falls between "Start Date" and "End Date." Below is my current formula, but I continue get a returned value of "#DATE EXPECTED." =IF(AND(TODAY() >= [Start…
-
Sum of one Column based on another
I am trying to calculate the total (sum) of the column "mbrs" based on their affiliation (AFF,DNG,LITE etc). I have tried a =Countif(=Sum(range), criteria) type of formula with no success. Any suggestions on how to calculate without having to filter and count each separately I have over 6k rows.
