-
I need to separate out digits between characters (_) into a different column. Can this be done?
Hi there … I need to separate digits from between characters (_) into a separate column. 100936_BLK_IE_JUL_20240718231356_24_HI_REGULAR_4.ps 100936_BLK_IE_JUL_240718231626_6_HI_REGULAR_6.ps I need returned 24 and 6 from the strings above. Since there are multiple _ I'm not sure how to tell the formula to pull the digits…
-
Sumifs multiple criteria single column help
Hello, I'm having trouble creating a formula that will sum if multiple criteria in a single column are met. I want to sum LOE column when the capability = one of 4 values. I'm using the SUMIFS and OR functions to try to make this work in a sheet summary metric but getting the #UNPARSEABLE error. Found a few other posts on…
-
How to sum up values based on multiple criterions
This is sample data. I want to sum up original estimates (column circled with RED) by column EPIC# when: 1. non-epic helper ="Yes" 2. current jira status <> "Closed" 3. Jira# = Epic#. So, for 1st four rows, I should have sum=24+60+40=128. Next, 3 rows since don't meet all the criteria should give sum=0. I tried couple…
-
Status Updates for Parent rows of Children
I would like the parent of fields in a Status row to reflect Complete when all children are marked Complete or Cancelled. If all children are marked "Not started", then the parent should be marked "Not started". Otherwise, if there is a combination in status for children other than above, the parent should be marked "In…
-
Find the next date in a list INCLUDING the same date
I need some help, please! I've been all over discussions and tried everything I can think of but I can't get this to work. I have a table that tracks status change dates for our projects. The date and time is recorded automatically each time the status changes. I want to show how long each status takes during the process.…
-
(Resolved on my own) Formula issue ..
RESOLVED … I WAS USING THE WRONG COLUMN! I have written a formula to read columns on a different sheet. The column is working (no error messages) but it is reading "0" for everything. I've attached a couple of screenshots that demonstrate this. There is clearly 3 "yes" answers for the project but the formula is returning…
-
COUNTIFS always returns 0
I can't get my COUNTIFS equation to work, it always just returns 0, can anybody help? =COUNTIFS([Column A]@row, "None", [Column B]@row, "None", [Column C]@row, "None", [Column D]@row, "None", [Column E]@row, "None", [Column F]@row, "None")
-
Include line value in a sheet if creation date falls in a certain range
Hi all I need help with a formula in a budget sheet. All orders my team creates are on 1 sheet per fiscal year. My issue that I have is to report on a monthly basis what was spent on each month. I would like to find out what formula I can use to calculate the order amount in a certain month. Hope this makes sense. :)
-
Ranking/VLookup Formula with Duplicates
I have an issue with my sheet where we rank the total number of projects closed from 1-5. Rank is in the first column, second column is a formula: =MAX(COLLECT([Total Project Closed]:[Total Project Closed], [Rank for Completion]:[Rank for Completion], [Rank for Sheds Comp]@row)) this returns the number of projects closed.…
-
Confounding Behavior with IF Statement
Hello all, I've run into an issue around what should be an entry level IF statement. I'm comparing numbers in two columns, one of which is derived from a time calculation. The formula is looking to determine if the two values are greater than or equal to one another and outputs a simple "Yes" or "No" depending on the…
