Discussion List

  • Formulas with reports
    In Formulas and Functions
    Hi, 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 1
    Answered - Pending Review 6 views 1 comment Most recent by Heather D Formulas and Functions
  • Rolling up Health to the Parent row
    In Using Smartsheet
    Is 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…
    264 13
    Accepted Answer 264 views 13 comments Most recent by Irene D Using Smartsheet
  • Pivot tables grouping
    In Premium Apps and Integrations
    In excel you can group pivot table rows by days under the "PivotTable Analyze" tab. Does Smartsheet have the same functionality?
    7 0
    Question 7 views 0 comments Started by William Briggs Premium Apps and Integrations
  • How to make a COUNTIFS Formula work
    In Formulas and Functions
    Hello, 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 …
    39 10
    Accepted Answer 39 views 10 comments Most recent by Heather D Formulas and Functions
  • Report filter help (filters out all results)
    In Using Smartsheet
    Hello, 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…
    Answered - Pending Review
    7 4
    Answered - Pending Review 7 views 4 comments Most recent by Joanna Lupker Using Smartsheet
  • Project Plan - Manually Changing "Start Date"
    In Formulas and Functions
    Hi 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 help
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Need help in AverageIf formula with 2 condition
    In Formulas and Functions
    Hi 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…
    16 3
    Accepted Answer 16 views 3 comments Most recent by Mark Cronk Formulas and Functions
  • Reports & New Columns
    In Using Smartsheet
    Hello - 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…
    568 3
    568 views 3 comments Most recent by Daniel Morriss Using Smartsheet
  • Calculating percentage based on status options across multiple columns
    In Formulas and Functions
    I 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 3
    Answered - Pending Review 18 views 3 comments Most recent by John Hageman Formulas and Functions
  • Filtering by a Summary sheet field in a Row Report
    In Using Smartsheet
    I 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…
    10 2
    Accepted Answer 10 views 2 comments Most recent by Maurizio Caputo Using Smartsheet