-
How to return a MAX Value of "0" if Remaining # of Weeks is < 0
Hello Amazing Community, I'm trying to create a formula to Remaining Number of Weeks on a project. Start Date = 5/30/23 End Date = 6/15/23 Formula for Remaining # of Weeks (from today) =NETDAYS(TODAY(), [End Date]@row) / 7 = -2.9 **Problem is when End Date is in the past, and TODAY keeps changing, in which case, Remaining…
-
Countif specific type and year
=COUNTIFS(Type:Type, ="CTA New"), ([Date Submitted]:[Date Submitted], IFERROR(YEAR(@cell), 0) = 2022) I've been looking at examples of this question all day - but for some reason I can't make my formula work. The above formula is #Unparseable. I want to count the number of rows with "CTA New" Type and 2022 Date Submitted…
-
Total time-off days by year
I am having trouble creating a formula on my Staff Total Days Off sheet that pulls information from my Time-off Request Log sheet but for a specific year. Sheet 1: Time-off request sheet tracks each employee's approved time-off dates and days with an additional column for YEAR of request. Sheet 2: The Total Days Off sheet…
-
AverageIf with multiple criterion
I would like to find the Average Resolution time (Days) for rows where the date closed is in June 2023. =AVERAGEIF(AND([Date Closed]:[Date Closed], >DATE(2023, 6, 1), [Date Closed]:[Date Closed], <DATE(2023, 6, 30)), [Resolution Time (Days)]) I'm getting Invalid Data Type. Thank you in advance!! Jennifer
-
COUNTIFS+CONTAINS+AND
I am trying to write a sheet summary formula to count the number of rows where: Sprint Name contains "Maintenance", Date Resolved is not blank, and Bug or Request equals "Bug" [Sprint Name]:[Sprint Name], CONTAINS("Maintenance") and [Date Resolved]:[Date Resolved], <>"" and [Bug or Request]:[Bug or Request], "Bug" I tried…
-
Formula help needed: multiple combinations
Hello, I am in need of help with a formula. Basically, I have a formula looking at column A. Column A has 9 drop-down options, multi-select. Each of the 9 options has a specific (i.e., different) email associated with them. I have a large IF function that will accurately give the appropriate email, based on a single…
-
Formula on Children
This is likely an elementary question, but I am having a challenge to get the formula for the Count of Children when I have the formula, for example, in a column B cell and I want to count the children of column A. What am I doing wrong?
-
Formula Help
Hello, I recently used this =SUMIFS formula and now that I have changed some VLOOKUPS the formula gives me a #NO MATCH error. SUMIFS([Request Total]:[Request Total], [Employee ID]:[Employee ID], [Employee ID]@row, Date:Date, <=Date@row, Date:Date, >=DATE(2022, 7, 1), [Department Approval]:[Department Approval], "Approved")…
-
VLOOKUP across Multiple Sheets
I am trying to have a cross reference that looks across 3 different sheets. I have been successful getting it to work with just two sheets, but when i add the third, it comes back "INCORRECT ARGUMENT SET". Any help is appreciated. Here is my formula =IFERROR(VLOOKUP([Employee Email]@row, {Supervisors 1 Range 1}, 2, 0),…
-
How do I create an IF functions that will change my status color if information is in the cell
I am trying to have my event status which is (symbols) update to gray, red, yellow, or green depending on if 2 cells contain information (Green), or one cell or no cells have information and is more than two weeks from the date (yellow), one or no cells have information and is less than two weeks from the date or event is…
