-
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…
-
Current Week
I'm working on a project where I need to identify Current Week and Last Week. In the below screenshot 08/28/22 is a Sunday (1). 08/28 - 08/31 should show as Current Week but 08/28 shows as Last Week. I've tried to change several things but can not get Sunday to become part of the current week. Any thoughts on what I doing…
-
How to extract the Row # digits from the Predecessor column
Here are some samples of what I have... 19FS -2d (I want to extract "19") 17SS (I want to extract "17") 762SS, 22FF (I want to extract "76" to one cell and "22" to another cell) Any ideas?
-
SUM & SUMIFS
I have columns named: Item Description (That contains within a text (Z123) Quantity Received (Check Box) Not sure if you can use SUM and SUMIFS in same formula Looking for a result of ~~ Out of a total of (NUMBER) you have received(NUMBER). Thanks!
-
IFS & COUNTIFS/ MATCH, NO MATCH
Below is a screenshot of my sheet. I have count if, Match referencing another sheet with this sheet. Individual columns will show " MATCH"- ( DATE MATCH TEST 2022:Invoice Date) (Payee:PAYEE TEST MATCH 2022) But the COUNTIFS IN the (2022) Column matching payee & date is returning NO Match. The data is clean in both sheets,…
-
Hierarchy Drill Through Solutions?
I feed my sheets into Power BI (pre-formatted gantts) and I need to create a way to drill down through levels of a sheet's hierarchy. Ideally, at least 4 levels of the hierarchy, Great Grand Parent, Grand Parent, Parent, Child, if you will. I'd like to mimic the concept that's in MS Project, on the View tab, Data group,…