-
Split and join multi-select values into new column
Hi, I'm attempting to get a function as per below. I've tried a few methods and it doesn't seem to work. Can anyone help?
-
Formulas to calculate the number of weekdays, Saturdays, and Sundays between two dates
I have three columns: Weekdays, Saturdays, and Sundays. I need to calculate the quantity of each of these three types of days based on start and end dates. The NETWEEKDAY and NETWEEKDAYS functions do not work in this case because the start and end dates should be included in the count. Example: Start date of 8/22/2021 and…
-
Formual to calculate highest point total summed by Name
Hello - Trying to return a name (Talent) with the highest total of points (Points Awarded) summed. So the points have to be summed by name (Talent) and return the name(Talent) with the highest points awarded totaled. I've started with this: =SUMIF(Talent:Talent, Talent@row, [Points Awarded (Numbers Only)]:[Points Awarded…
-
Referencing a chosen date in Index/Match function
Hello, I am looking to reference a date of my choosing from my sheet summary (shown below) (want to be able to edit the date value to filter the data based on certain weeks) in my Index/Match function, I have it set up currently so that it works using the "current week" but I would like to adjust this so that myself or…
-
Return 0 instead of negative number
Hello, I have a formula that calculates the number of years between contract dates and a second formula to calculate time remaining. The time remaining formula works as expected before reaching and passing the date of expiration within the formula. Currently, when the date of expiration is either met or have past, the…
-
Exclude and If statement then "" and based on date then "Return Value"
=IF([Tier Status]@row <> "Group D", IF([Escalation Required]@row, <>"", (IF([WM Next Meeting Date]@row = "", "No Meeting Scheduled", IF([WM Next Meeting Date]@row = TODAY(-14), "Pending", IF([WM Next Meeting Date]@row > TODAY(-1), "Scheduled", IF([WM Next Meeting Date]@row < TODAY(-14), "Overdue"))))),"Escalated")) What…
-
A Contains function to find at least one option from a multi select column
I am using this formula =COUNTIF({Activities}, CONTAINS(Activity@row, @cell)) to count if a column in another sheet has a specific activity. Both columns are multi-select and if there's a single activity in the Activity@row, it works fine, but when I ad a second activity to the row, it no longer counts it because the other…
-
Help with formula in Project Office Management template set
Hello, I'm using the Project Management Office template set and one of the default formulas appears to calculate the schedule delta with the following formula - =IFERROR([Schedule Delta (Working Days)]@row / Duration@row, "") Can someone help me understand how it's calculating? I would expect the status of the Schedule…
-
VLOOKUP
Column1 Column2 Column3 1 1/1/20 Complete 3 1/1/20 Pending 2 1/1/20 Pending Column 4 Column5 Column6 3 1/1/20 Complete 2 1/1/20 Pending 1 1/1/20 Complete I need a formula that can identify when one of the cells in the first three columns is different from the cells in the last three columns. In this example, 3 should be…
-
I want a formula that counts (Request Type by Month).
I have a metrics sheet and the RE Execution Request sheet and have attempted many versions of this formula for the highlighted cell: =COUNTIFS({HEOR Research Execution Request Form Range 4}, AND(IFERROR(MONTH,0) = 8, IFERROR(YEAR,0) = 2021, {HEOR Research Execution Request Form Range 1}@cell = "Prospective Research…