-
RAID Metrics
I'm trying to figure out how to build a formula using the COUNTIFS function that will count the number of ACTION items in our raid log but only if those items don't have one of our multiple closed status's. ONLY Active items if you will. Current Formula: =COUNTIFS({RAID Type}, "Action") - this returns the correct count of…
-
Formulas within conditional formatting?
I believe this must be possible, right? I have two column 2 my on hand amount and column 4 my par. I want the row to highlight red if the on hand amount is less than the par. Tried to use @row within the conditional formatting but it seems only be highlighting when the on hand amount is less than 1 not less than the par…
-
sequential letters
I have a sheet where I have parent and child rows, and I would like one column in the child rows to have sequential letters. I have a picture here. I have a parent/child column that would normally be hidden, but I count the number of children so obviously the parent will have a number greater than zero and the children…
-
count the number of tasks due within 30 days
This discussion was created from comments split from: Formula Woes.
-
Nested If Statements
Rookie here - can someone please tell me what I'm doing wrong? =IF(AND([Started?]@row = true, (TODAY(20) > [End Date]@row, "Urgent", IF(AND([Started?]@row = true, (TODAY(7) > [End Date]@row, "At Risk", "Not Started")))
-
Does "You can only reference a total of 100000 cells from other sheets." apply to 1 or all sheets
I have 2 sheets consolidating data from 2 source sheets. One of my consolidation sheets works fine, pulling data from both source sheets. The second consolidation sheet fails whenever I attempt to change the sheet reference in some cells to point to the second source sheet (which I was able to do on the first consolidating…
-
VLOOKUP to calculate dates - holidays = due date
My Eval Pull date is based upon the TCP Type the user selects and also needs to calculate in the holidays. Currently, Eval Start Date has a reference to another cell =[Date Completed]32 Once the Date Completed/Eval Start Date has a date, based upon the users pre-selected TCP Type of 115 days (VLOOKUP to TCPTypeDropDown and…
-
Month from Date column
Good afternoon! I think I may be overcomplicating this. With the below, I'm trying to pull the month based on A. However, as it was a drop-down for the purposes of the form, I copied it as a date column in B. I included a legend of what is what and what I'm trying to get is the formula for D through F to work. What am I…
-
Need help with a sumifs formula
I need to figure out why my "sumifs" formula is not working. I want to total a duration column if a payroll Item column contains one of 3 possible choices. My formula is as follows... =SUMIFS(Duration:Duration, Payroll Item:Payroll Item, "Hourly",[Payroll Item:Payroll Item, "Overhead Hourly"], [Payroll Item:Payroll Item,…
-
7 Day Average/30 Day Average
I am trying to build a formula for a data set that I can calculate as a complete average, but I'd like the 7 day average and the 30 day average. Here's the formula that works: =AVG([% Successful]:[% Successful]) I know I will need to use AVERAGEIF, but can not get the date parts correct. Thanks for your help!