-
How do I count 2023 Q1 items that are not specific request statuses?
Here is my formula: =COUNTIFS([Plan of Record]:[Plan of Record], FIND("2023", @cell) > 0, [Request Status]:[Request Status], NOT(CONTAINS("Cancelled", @cell), NOT(CONTAINS("Merged", @cell), NOT(CONTAINS("Rejected - Insufficient Value", @cell), NOT(CONTAINS("Rejected - Duplicate", @cell)), [Planned MVP Launch Date]:[Planned…
-
Why am I receiving #INVALID OPERATION error in some of my sheets
I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health. =INDEX(Health:Health, MATCH("Task A", [Task…
-
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…
-
COUNTIFS Errors
I'm trying to create a Sheet Summary field formula that will count up the number of "Yes" (formula-generated, if that matters) cells in a column if the date, in another column on that row, falls within a given month/year range. This one seems to be working... I think: =IFERROR((COUNTIFS(OTD:OTD, OR(@cell = "Yes", @cell =…
-
Cell range and Sheet Summary
I have an expense 'tracker'. Essentially it tracks if employees submitted their expenses (1) correct the first time; (2) expense was sent back for revision; (3) submitted late (4) did not submit My columns across top are months of the year. My rows are employee names. I have a sheet summary that totals (1), (2), (3) and…
-
SumIf Date Range
Hi All! I'm trying to use the Summary in a sheet to tabulate an object count between a date range. I'm trying to get a Sum of cells in a column "Number of Objects", if the "Date Imported" is between a range, 09/01/21- 08/31/22. The formula I'm using is returning "0". The formula is : =SUMIF([Date Imported]:[Date Imported],…
-
Formula to return the average of points assigned to a specific person within a specific date range
Hi all, I have a fairly complex formula I'm tying to create, and can't manage to make it work. Let's say my data sheet has three columns, representing a point value given to an individual on a specific date: Person (Number/Text, each cell contains one name) Points (Number/Text, each cell contains one number) Date (Date,…
-
Sum dollars based on names in multiple columns
I have a shared tips sheet. A big tip is divided by the coaches that are coaching for the group. If John is coach 1, Dave is coach 2, and Skye is coach 3, then the $30 tip would be split $10 each. The next group may have Skye , Mike, and Nate and may have a $60 tip. Etc. I am trying to write a formula that says of Skye is…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…
-
Ability to “freeze” the Gantt Chart Bar
When a sheet is showing the Gantt Chart and you open the Sheet Summary, the left side of the Gantt Chart is pushed left to make room for the Sheet Summary. When you close the Sheet Summary the left side is not returned to where it was. EVERY TIME we access the Sheet Summary we need to drag the Gantt Chart back to where it…