-
SUMIFS with multiple criteria per quarter
Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_local - want to only find those designated "national" Start_date - only need between 1/1/2025 - 3/31/2025 Reach - need the…
-
Sheet Summary Formula to Rollup Parent Statuses
Hi, I have a working formula in my sheet that works beautifully to rollup/count the status within the sheet: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress",…
-
Can analyze data be used in sheet summary or dashboard
It would be great if the analyze data tool could be copied to the sheet summary or dashboard to continue to be updated as new data comes into the sheet. Is this possible?
-
Need help with a couple Formulas for On hold and Certain Counts
First formula - In a sheet, in sheet summary I need a formula to count the instances certain Project Channels show up. There are three that will need to be counted. For now let's just call them Channel 1, Channel 2 and Channel 3. They are a dropdown column. Second formula - same thing-same sheet and sheet summary formula.…
-
Summary Report for multiple fields on one sheet
I need to create a Summary Report for multiple fields on one sheet. I am successful in getting the COUNTIF statement to work on one of the columns, but when I add fields for a different column, the count is not rendering the correct results. I am using this formula for the Overall Health functions - =COUNTIF([Overall…
-
Is there a method to copy sheet summary values to another sheet?
I'd like to create trend reports on project data over time. For example, I use a sheet summary to total completed story points for a project. I update the project metrics in my sheet every 2 weeks. I need to capture the value of the summary field for each 2-week sprint so I can develop trend reporting (velocity, etc…) over…
-
Listing Sheet Summary Fields
Is there a way to get a list of all of the sheet summary fields in a sheet with their formulas? For example SummaryField1 = COUNTIF(Field1,="1") SummaryField2 = COUNTIF(Field2,="2")
-
Tracking Missing Submissions
Hi! Thank you for considering this problem, I am very new to Smartsheet. I have a form that I have 10 regions complete monthly. There is a due date for each month. I would like to generate a report of those of the 10 regions that did not submit a report monthly. How would I go about doing this? Thank you again!
-
Sheet summary dropdown field not accessible on mobile
The sheet summary is accessible on the mobile app but the fields can not be edited, is this true?
-
JOIN function in a Sheet Summary
Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summary (or if I even can do this). This is the function I'm currently using in a column titled Milestone Complete:…