Hi Community Have used the formula posted to this forum to identify duplicates in a single column using [IF(COUNTIF())} formula. I have a site/dept type issue split across two columns and need to iden…
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 ke…
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/20…
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 …
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 d…
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 us…
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 s…
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 form…
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 s…
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 Q…