-
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
-
Challenges with combining SUMIFS and COUNTIFS
I am using the Sheet Summary to input formulas helping me to track the COUNT of installs that took place in a given month/year. But now I want to SUM how many assets were installed at that location using the same date criteria. My formulas below are allowing me to COUNT how many rows (AKA customer locations) fit my…