-
IF AND Formula Help
Hi everyone! I am hoping you can please help me. I have tried IF AND, IF OR, and IF CONTAINS formulas but nothing works. Referencing the below screenshot, I have a checkbox in the column titled "Carry Forward". I want to have the check box checked when the column titled "Vacancy Status" contains either the word "Assigned"…
-
Formula for Modified Date
Hello, I want to keep track of End Date changes on workstream plans. Aware the automated Modified Date column is updated following any change to that row. I want to find a way to populate a Changes Log with specific information from a row, if the End Date Column has been updated. Unfortunately, the layout of the activity…
-
Build Report that shows "Child" lines items under the "Parent
I am trying to build a report from a sheet that has a parent line item with child line items. I need the report to show the parent and the child. Then have the ability to group by the parent. When the parent is expanded it shows the children. My report currently looks like this...all the indented child line items are no…
-
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…