-
Sheet Summary Won't Count # of Cells with %
Hello, I have a sheet that has a column for % complete and I cannot get the formula in my sheet summary to count the # of cells that are 25%, 50%, 75% or 100% complete. The formula I'm using is =COUNTIF(Percent:Percent, "25"). This seems to work to count any that are 0% but none of the other numbers. What am I doing wrong?
-
Calculating a Total Occurring within a Specific Month (SUMIF)
Hello, I am working off the provided personal car mileage tracker to create a monthly total for an employee. I am creating a sheet summary formula. My formula isn't giving me an error but it isn't calculating either! I've tried it with and without the parent/child indentation and same result. I want to calculate the total…
-
Count Column if cell does not contain
I am working on a sheet summary formula. The column in question has a formula that will indicate a task is complete based on other criteria. I am trying to calculate the number of rows that are not reading "Complete" in the summary. The formula for that column will return a numerical value for other rows, based on how many…
-
Date validation formula referencing Sheet Summary fields
Hello, I'm trying to update a date validation formula to include a reference to two Sheet Summary fields. The formula seems to be working -- except for the piece that references these Sheet Summary fields (in bold): =IF(OR([Preferred Date*]@row = "09/04/23", [Preferred Date*]@row = "11/23/23", [Preferred Date*]@row =…
-
Count Day Between IF
I am looking to count the days between two columns, if a third column meets criteria. Compare Due Date and Collection Date, counting the days between if Test Type is "Random"
-
Sheet Summary Report Chart
I continue to get an error when I try to create a chart of a Sheet Summary Report. The error states "Selected Data can not be charted. Please select a new range". The data is pretty straightforward, its a list of 15 locations with a completeness between 0 and 100. I tried removing the percentage in my sheet summary…
-
Failing to post date value to Summary field
I am working with the python sdk, and I cannot figure out how to post a date value. Here is a picture of what I am doing. where sum is a dictionary of posting data If I am trying to post a formula, I check that my "Posting value" has a equal sign, and then the formula goes there, and it posts fine. If I am trying to post a…
-
Is there a formula to get the average of star ratings?
I have a column that is only star ratings. I am trying to the get the average rating of the entire column in a sheet summary field. I tried to just do the average formula for the column and got the #DIVIDE BY ZERO error. Is there a formula that can calculate the average without having to create a helper column to translate…
-
'Lock' a sheet summary field or workaround for a copy-and-pastable value?
Hi folks, I have a sheet summary field that pulls a value into my sheet from another sheet. It's a weblink although in theory it could be anything that someone might want to copy and paste rather than just read. The link pulls through as expected but when my users (who are editors, for they are required to edit other items…
-
Formula no longer working in Sheet Summary
I have a sheet with sheet summaries that were working for the last month and I recently updated with data shuttle and its no longer working. I keep getting the sum of 0 even though it was working before. =SUMIFS([Quantity (G)]:[Quantity (G)], Material:Material, CONTAINS("200002", @cell), [Pick-up Date]:[Pick-up Date],…