-
Creating a survey & collecting feedback for a list of submissions
I've created an intake form and sheet to collect project request submissions, and now need to create a way for the project committee (8 members) to score each submission using a simple 4 value Impact/Effort score that I'd like to present in a Survey Form so I can collect the data and consolidate for presentation on…
-
Is TODAY() supported as a Sheet Summary Field?
I am trying to get a sheet summary field on my project plan to count the number of tasks which have fallen behind plan. However I do this, I am using the TODAY() function, either in a sheet column or in the summary field itself. Here is one example of something I tried in the sheet summary field: =COUNTIFS(Status:Status <>…
-
Include Sheet Summary fields in Row Reports
I've seen several queries about this, and workarounds but can't find a suggestion so here's one! I have multiple sheets with the same name (in different workspaces). I want to use a Row Report but separate out / summarise the entries per sheet. The only field I can use is "sheet name" which is the same for all, but what I…
-
How to change the name of a Summary Field on a Dashboard?
Maybe a dumb question but I can't figure out how to do it or if it can be done by searching on the Community. I have a source sheet of client data that's summarized into 3 Summary fields by the assigned specialists. I've then pulled those 3 fields separately into several Summary Reports that I used to build tiles on a…
-
Sheet Summary with SUMIF
I'm trying to pull in expenses tied to a specific category and based on a specific month. I've been trying to make this formula work but keep running into "Incorrect Argument Set" and "Unparseable" messages. I've tried to edit this many different ways and cannot get it to work. =SUMIF([Expense Category]:[Expense Category],…
-
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…
-
Copy Sheet Summary Field on a Sheet
The ability to copy an existing sheet summary field and edit to save with modified formula.
-
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 =…
