-
COUNTIF Formula Providing Incorrect Result
Hello! I am adding sheet summary fields to count the rows for each status. I noticed that the results I get with my COUNTIF formula are incorrect. The correct results would be: Completed - 3, In Progress - 1, Not Started - 2 (this one is correct) I tried this formula on a second sheet and still received an incorrect…
-
Tagged Comment Fields
Would be two suggestions, one is ability to add tags/categories to comments. Second would be ability to configure the tag(s) to be shown in the latest comments column that was recently added We use multiple columns to add notes and comments for a mission from particular program areas such as volunteers, logistics, safety…
-
Real-time Update for Sheet Summary
Hi, I have a sheet with months as columns. I have a formula to calculate monthly percent compliance when the numerator and denominator is entered into the sheet. For my sheet summary, I would like to see it update in real-time with the latest average percentage calculation, meaning it would show the average of percentage…
-
Using dates in sheet summary formulas
Hello, I have a sheet that is pulling data from Microsoft Dynamics CRM using the connector where the date data is not coming across correctly if the column is setup as a date format. I have therefore setup the column in the sheet as a text field. I have a summary formula which uses this column to summarize data by quarter…
-
VLOOKUP or INDEX MATCH Referencing Another Sheet
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({Program Intake Form Range 1}, MATCH([Project #]#, {Program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {Program Intake Form Range 2}, 5,…
-
#NO MATCH error on a Sheet Summary Formula
Hello, I'm guessing the problem is because the field I'm referencing is a formula and not a value, but would appreciate suggestions on how to handle this. I want a sheet summary formula to return how many Variances exist for each VarianceCategory, so I can use this information in a report. I've listed the formulas that I'm…
-
Merged: Global Update Find/Replace & Sheet Summary
This discussion has been merged.
-
Sumif Formula Question
I have a sheet containing a Time Block column as well as a Type column. Both are dropdown columns one with time in hours (.24, .5, .75, 1, 2 and so on), the other has types of activities (Dev Meeting, General Admin, and so on). I am trying to build a formula that adds the time for each activity by the month. I can't get…
-
Sheet Summary fields not showing all data on Report
Please see the image. For some reason some sheet summary fields are not displaying on the report and others are. All are visible when I view the fields from the report. I've tried moving the sheet to a different workspace and folder, changed the values in the fields, etc., nothing works. Why are the green showing just fine…
-
Why isn't my COUNTIF formula updating?
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the data from is a dropdown selection - which I have never had issues with before now. When I plug in the formula, it registers…