Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

Discussion List

  • In a Gantt with many rows, how to color a date range that spans all rows in a column?
    In Using Smartsheet
    In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want i…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Scott Rapoport Using Smartsheet
  • Is it possible to change who an automation is sent from?
    In Formulas and Functions
    We have an automation in place to notify an employee when they have received a nomination. That nomination is submitted via a form by another employee but we do not want the employee that has been nominated to know who submitted the nomin…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by VickyA Formulas and Functions
  • Date comparison, if greater than 30 then flag
    In Formulas and Functions
    Hello, I have two date columns that I would like to compare. The first column is named Requested and the second column is named [Sign off on]. In a third column formatted for symbols is where I've written the following formula, =IF([SIGN O…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Mily Oti Formulas and Functions
  • Average If using a list rather than a range
    In Formulas and Functions
    I need to take an average if the data is greater than zero. I got it covered when the data is neatly organized in a range: =AVERAGEIF([Chart Data]79:[Chart Data]82, >0, [Chart Data]79:[Chart Data]82). My issue comes in when I try the …
    Accepted
    19 9
    Accepted Answer 19 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Formula Looking at 2 Dates
    In Formulas and Functions
    Hi! I'm working to track whether or not the need by date entered on request forms abide by our 7-business day SLA. The goal is to see out of the requests that were not completed by the need by date, how many of those requests were outside …
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Company Dashboard Examples
    In Using Smartsheet
    I have created some dashboards for each department in our company and I'd like to create a company dashboard where you could see a company overview with a link to each dashboard and to department info. Would anyone be willing to share ima…
    Unresolved
    29 2
    Question 29 views 2 comments Most recent by Andrea Westrich Using Smartsheet
  • Smart Sheet Super user charactistics
    In Using Smartsheet
    What personal characteristics do you look for when selecting Smartsheet Super Users for your organization? For example: Critical thinking skills
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Charts in Dashboard
    In Using Smartsheet
    Hello- Has anyone had any issues with not all of their data selected for the chart actually showing up within their selected graph within their dashboard?
    Answered - Pending Review
    22 9
    Answered - Pending Review 22 views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Smartsheet Dashboards
    In Using Smartsheet
    Hi! Is there going to be anyway that you can download Smartsheet reports instead of having to "print" them one by one if you have a bunch of them? Thank you! Jenna
    Answered - Pending Review
    13 5
    Answered - Pending Review 13 views 5 comments Most recent by Paul Newcome Using Smartsheet
  • Report Sheet Name Column Format Inconsistent
    In Formulas and Functions
    I'm finding when I build a report for a collection of sheets or a workspace, the formatting of the Sheet Name column is inconsistent from line to line. I have the report grouped by Project Name with the information coming from a workspace …
    Answered - Pending Review
    10 3
    Answered - Pending Review 10 views 3 comments Most recent by Paul Newcome Formulas and Functions