Reporting
Discussion List
-
Formulas with reportsIn Formulas and FunctionsHi, I've combined two sheets into a report and I was hoping to do a summary sheet with various sumif formulas based on the data in the report. When I build the formula, the report is not an option in the list. Please advise. Thank you!Answered - Pending Review 6 views 1 comment 0 points Most recent by Heather D Formulas and Functions
-
Rolling up Health to the Parent rowIn Using SmartsheetIs there a way to roll up health of tasks underneath the parent to reflect an "average" health, if you will? I have a formula for my children to render health, however, I can't seem to roll up to the parent. Would the same formu…
-
Pivot tables groupingIn Premium Apps and IntegrationsIn excel you can group pivot table rows by days under the "PivotTable Analyze" tab. Does Smartsheet have the same functionality?
-
How to make a COUNTIFS Formula workIn Formulas and FunctionsHello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff …
-
Report filter help (filters out all results)In Using SmartsheetHello, I'm trying to figure out what conditions are making my filtered results completely blank. This is the current data I have appearing and I want the top to rows to be filtered out based on their value in the "Division" co…
-
Project Plan - Manually Changing "Start Date"In Formulas and FunctionsHi Team, Can anyone help me why I am not able to manually change the start date .. I want this functionality to be disable so that the user can manual change start date related to task name assigned. Please helpAnswered - Pending Review 8 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Need help in AverageIf formula with 2 conditionIn Formulas and FunctionsHi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of trans…
-
Reports & New ColumnsIn Using SmartsheetHello - it is possible to add new columns to a report? Ie - add new blank columns? Looking at a strategy for planing where reports issue up to date information, and each team adds on their own relevant columns of information, driven fr…
-
Calculating percentage based on status options across multiple columnsIn Formulas and FunctionsI am trying to average the sum across multiple columns. Each column is a single select dropdown that will allow the user to choose from the following options: ⦸ (Not applicable) ◷ (in progress) ✓ (Complete) I want to assign val…Answered - Pending Review 18 views 3 comments 0 points Most recent by John Hageman Formulas and Functions
-
Filtering by a Summary sheet field in a Row ReportIn Using SmartsheetI am trying to create a report that will include not completed tasks from all my projects with a due date either 5 days in the past or 5 days in the future. This way I can look at it and either get updates or make sure the resources are wo…
