-
NETWORKDAYS
PROBLEM SOLVED THANK YOU
-
IF CONTAINS Help!
Good morning, I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.…
-
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 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),…