-
Need help with AVG(Collect - multiple criteria same column
I'm trying to use Avg(Collect to get the average number of days from another sheet. My problem is I need to search one column for 2 key words. Is Avg(Collect similar to Countifs( where you can't do this? The below formulas work (XXX is a holder) separately but I'm at a loss for how to combine them to yield the correct…
-
RANKEQ
i try to ranking the number column with some criteria with this formula: =IF(AND(HAS([Product Category]:[Product Category]; "Google"); OR([Stage Category]@row = "Healthy"; [Stage Category]@row = "Stuck")); RANKEQ([Sum of Total Contract Value (converted)]@row; [Sum of Total Contract Value (converted)]:[Sum of Total Contract…
-
SUMIFS to show daily hours worked
I have a report that is emailed daily that I upload into SS using Data Shuttle. I added Date Column and ID so it always add the row. It looks like this: Now I need to create a formula that link these hours to our metric sheet so we can track their productivity. This is the last piece of the metric. For each row, I have the…
-
Link an entire column from one sheet to another
Hey guys, I have 2 sheets, one is VS EE (the source sheet) and the other is VS BD (the destination sheet) I'm trying to link a col "Epic" from VS EE to col "Epic" in VS BD. Linking won't work for me because I need the new rows also to be linked. Another thing is that I don't have any cols to match. I just need that col…
-
I want to avoid an error message on a SUMIFS function.
Here is the function: =SUMIFS(Amount:Amount, Date:Date, YEAR(@cell) = Year@row, Date:Date, MONTH(@cell) = CurrentMonth@row) This works to tell me the "Amount" of a specific month and year. The problem is I get an #INVALID DATA TYPE message if the cell in the Date column is not populated but the cell in the Amount column…
-
How can I create a NETWORKDAYS formula that results in a blank field until an End Date is specified?
I need a column to show =NETWORKDAYS(([Start Date]@row), ([End Date]@row)), but currently the rows where End Date is blank are returning #INVALID DATA TYPE in my formula field. I would like it remain blank until an End Date value is entered. =IF(NOT(ISBLANK([End Date]@row)), "Not Blank", "") returns the expected result.…
-
date formula - how to add a time frame in the formula (2021 vs 2022)
Hi I am trying to add one more piece to my simple formula. I need to count the Released items in report for 2021, and for 2022 separately. So that we can see if the work done last year is smalle or bigger to what was done this year. So I am trying to add a date condition, preferably one that would be easily modified after…
-
What is WORKDAY formula with SLA built in
Hello, I'm seeking a way to add in a formula that runs left to right. When a start date is added to kick off a set of activities, the cells on that line calculate +2 days (what I'm calling SLA date/ service level agreement date) AND also makes the date a WORKDAY (no weekends or holidays). Thank you so much
-
Need help with this formula
Hello, Can someone recommend a formula to provide an average based on a name on the row. Example, I will have 4 rows for each person but want to average the scores for that person. Image below: Thank you for your help. Rebecca
-
Sum values on another sheet based on two columns
Hello, I am attempting to execute the following formula: =SUMIFS({Transfer Amount}, {Transfer Type}, "Recognized", {Month Invoiced}, >=DATE(2022, 1, 1), {Month Invoiced}, <DATE(2022, 2, 1)) where I want to sum values in a column based on a 2nd column's criteria and a 3rd date column range. The formula worked in test sheet…
