-
Select Value, not the formula, in a cell.
Hello, I have a cell where I join a column of cells with keywords into a single cell. This combines the keywords from all the entries on the sheet into one cell for use in analysis of all collected keywords. I want to copy the combined keyword list, but I can only seem to select the formula that is generating said list in…
-
Extracting Month from Date
I would like to filter records based on a date in the past whose month falls within the next two months. For example, if today is 1/26/23, all records that fall between today and March 26 (i.e. 2/1/2019 would filter through). I can't figure out how to ignore the year (which will always be in the past).
-
RYG ball to determine priority involving multiple dates
I have a sheet that lists all active contracts for my department which all have expiration dates. However, I am struggling with this sheet because in all calculations I need to consider any extension dates. I do fine with calculations when there is one date involved but when I need to write them to incorporate two and…
-
combining vlookup with sum formulas
Hello Everyone, I am stumped again like usual and looking of help with getting a formula right. I am creating a data analysis sheet to generate sums and averages based on another sheet which has raw data. I understand how to do a sumif formula and separately how to write a vlookup formula, but I am struggling to combine…
-
Using COUNTIFS With Contacts, CONTAINS, and OR
I'm essentially trying to make a sheet summary formula for how many open cases someone in a contact list has at the moment. I've got it working when I'm looking at the contact list one way, but the users of this sheet have a bad habit of entering data so that their email address displays in the contact list rather than…
-
Sum(Children()) and Sum(row:row) not totaling correctly
I created a sheet to itemize costs on furniture orders. I used a hierarchy so I could just use =sum(children()) to see the total costs of each project. While the first project totaled correctly, the second is coming up with an additional $2919.36. First I went back to ensure all of the figures are correct, and they are. I…
-
How to use the COUNTIF formula when you have an OR statement that looks at multiple columns
I am trying to come up with a formula that will calculate how many tasks I have that are either "At Risk", which is a checkbox (flag) column, or has red health, which is a symbol column. I need a formula that does not add the totals of those conditions. For example, if a task is both At Risk and red health, I want that to…
-
Receiving INCORRECT ARGUMENT SET when using an IFERROR
This is the error I'm receiving on my sheet summary page. Please note that the sheet is "set up" with columns and necessary formulas, there is just no information entered yet. Every time I open this sheet, I get the error above. To fix this problem, I just copy the formula, delete it, then re-paste it. This is after I…
-
Adding a Date require to IF statement
Hello, I'm looking for assistance in adding some criteria to this AVERAGEIF formula to make it so I am only averaging dates from this year. =AVERAGEIF({Completed - Department}, =[30 Day Post Release Quality Score - Segments]@row, {Completed - AQualityP30D}) There is no AVGIFS so I'm not sure how to appraoch this any…
-
Need to add 6 months and 3 months to a date
I have a date that other will populate, but I need to have two columns that calculated 3 months out from the date and 6 months out. I have tried several formulas on the forum and nothing is working. I am completely stumped. If I was in excel this would have been done in a minute.