-
I need help with a SUMIFS formula to calculate total hours for an assignee based on dates
I'm working with a sheet that has a start date and due date, a column for assignee name, and a column for Hours/Week they're working on a project. I'm trying to get a formula to calculate the total hours an assignee is working throughout the sheet between two dates. I'm currently trying the formula below but it's brining…
-
Tracking Previous Week Order Completions vs This Week
Hello, This feels like a simple question, but the answer is eluding me. We have dates getting automatically logged for when orders come in/are delivered, and then another automation to log the date when the inspection is completed. I need to have two different results. One for when an order delivered from the previous week…
-
COUNTIFs Help.
Hello, I am trying to count how many times the names appear in the "Career Counselor" column, these are just a few examples, we have a few hundred different names and thought a formula would be easier. I have tried different formulas combinations using "COUNTIFs" without any success, please help. Thank you!…
-
Find next milestone in project plan
I have a project plan in which I want to write a formula to retrieve the next milestone, a task with a duration of zero, from a list of tasks. Task Name = Text/Number column Duration = Duration type column Start = Date column I have this formula which returns the first milestone in the Task Name list. The first task with a…
-
COUNTIFS date range less than 90 days from date in cell
Hey all, I can't find anything on this and struggling to come up with a formula looking at last 90 days from a set date. Please see attached screenshot for my current formula but I feel it shouldn't be this difficult and is probably something easy but currently stuck. My formula is not working because I have dates in the…
-
How do I Count the rows on a "Contact List" column, for the current user?
Example: I list team members in a Contact List by project. Team members range from 0 to 5 team members: Goal: count each team member's occurrences on 3 projects. Art Jones, Janice Doe, Terry Tonsil, Mary Green. Project Team Members (Contact list) Market Art Jones, Janice Doe. Inventory Terry Tonsil, Janice Doe, Mary Green.…
-
How to extract digits from a string that contains numbers and text (+ convert them to values)
Here are some samples - all I want are the digits in a new cell and for those digits to be values: 170, 191FF 47FF, 54FF 762SS, 22FF 751, 53FF +5d (but I don't want any number that has a "d" with it - "5d") It's gets complicated if I use IF statements to look for every possible combination of letters that may appear. I'm…
-
Does the INDEX / MATCH formula have to match exactly?
Can I use INDEX / MATCH for partial matches?
-
Turn Date Red
I am looking to turn the date red if past due + 7 days. Conditional formatting is not working. Does anyone have the formula to make this work? See screenshot below
-
Is there a way to create a WBS formula that produces only whole numbers
I need a WBS formula that produces numbers that will be nothing more than 1, 2, 3,.... 878, 879, etc., regardless of indents and outdents. I don't want, for example, "1.2.13.5" Is this possible? The reason I ask for a WBS-like solution is because if I rearrange the rows, I want the calculation to adjust accordingly. So if…
