-
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:…
-
Create a select all option in blueprint summary
The thing is, when you have to select like 100+ instead of only 1 checkbox… its a waste of time
-
Masking certain columns to viewers
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns or duplicate that spreadsheet, but not fill in the budget columns and then share that spreadsheet. Is there any option like…
-
COUNTIFS and SUMIFS formulas with multiple criteria AND a dynamic date range in a sheet summary
Hi everyone, I've had a look in the forum threads to try and find an answer already, but not sure what I'm trying to do is like-for-like with some of the suggestions. BACKGROUND: I'm helping colleagues with aggregating some of the data in their deployments sheet, which they use for managing and tracking their events, the…
-
I am creating in the calendar app from a Sheet summary report and it shows me an error