-
Need another set of eyes on SUMIFS formula in Sheet Summary
Hi and Happy New Year, Hope all is going well for you. In the Project Intake Sheet, I'm using the Sheet Summary to calculate metrics for reporting. On this particular formula, I keep getting #UNPARSABLE. I haven't been able to figure it out all day. Appreciate any input you may have! Goal: To sum the values in the ARR…
-
Compare Pre and Post Survey Results
I have a pre class survey and a post class survey. The surveys include both likert scale and fill in the blank questions. I would like to compare the data from the pre class survey to the post class survey in order to analyze and create metrics on improvement. Any ideas on how to actualize this?
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
Dashboard Assistance
Currently, I have a dashboard that reports on our Current and Completed jobs (two unique sheets). There's two fields I'm looking to add together and return the sum onto the dashboard to display our dynamic Currently Billed to Date number. Datapoint 1 - exists in the Sheet Summary for the Current Projects sheet. This…
-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Dashboard Reports Issue!
Hi All, I have unusual reporting issue which am unable to find solution in forum and am in need of some help. The issue: When I open dashboard one of the report just flick and then goes blank. Data / Filters testing: I've checked report, filters, all seems to be working fine and has correct data. Quick Fix: Refreshing…
-
Reporting: Multi-Select Data, Best Practice?
I have a multi-select column I'm trying to count instances of for each quarter of each year. I created a make-shift report using a sheet and I'm looking for help to determine if there's a better way to do this. Report I created: I've duplicated that sheet into more columns so I could share the formulas I am using. The left…
-
Count how many per Month and Year for Summary Sheet?
Hey - I'm trying to create a summary sheet for photo data. I want to count how many Photo shoots are happening per month/year. The screenshot is below is our "Comp" sheet that has the data I want to pull for the summary sheet. So ideally, I can then create a graph for a dashboard. The AI generated this formula:…
-
Sheet Summary Formatting - Sections with Headers, Dividers
I use sheet summaries often to help my team quickly see what the overall metrics are for a given sheet. I wish you could format the sheet summary to create sections. If I'm measuring three different types of metrics on a single sheet, it would be wonderful if I could create sections within the sheet summary for each of…
-
Pivot Table Summaries Getting #REF Error?
I have a few pivot tables set to update weekly, and seem to be refreshing the actual numbers just fine. However, I have some summary functions set up that have totally stopped working, instead giving a #REF Error: I'm a little surprised, as it worked perfectly (with real cell references, not #REFs) when I originally set it…