Discussion List

  • Blank Report
    In Using Smartsheet
    I shared a report with a customer. When the customer opens the report it is blank. It doesnt show any of the data? I tried sending a link to the report as well. Still nothing in the report. The customer setup a username and password. Im…
    1719 13
    1.7K views 13 comments Most recent by StefanieM Using Smartsheet
  • Rich Formatting On "Summary Sheet"
    In Formulas and Functions
    I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from mul…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by GabeHarris Formulas and Functions
  • Disregarding N/A in Formula
    In Formulas and Functions
    Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Sum…
    Answered - Pending Review
    24 6
    Answered - Pending Review 24 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Adding a report to a dashboard with a "Calendar" view vs "Grid" view
    In Using Smartsheet
    Hi - I'm trying to add a "Team Vacation Planner" to a Dashboard with a "Calendar" view vs a "Grid" view. No matter what I do, I still get the report in the "Grid" view. Any ideas?? Thanks in advanc…
    CJB Profile Photo CJB
    Answered - Pending Review
    53 3
    Answered - Pending Review 53 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Printing Grouped Reports
    In Using Smartsheet
    I have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is th…
    Answered - Pending Review
    1652 41
    Answered - Pending Review 1.7K views 41 comments Most recent by Eric OEC Using Smartsheet
  • Dropdowns in a dashboard, is it possible?
    In Using Smartsheet
    I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …
    1604 13
    1.6K views 13 comments Most recent by Gaurav K Using Smartsheet
  • How to Alter the "Sheet - IT Ticket Metrics"
    In Formulas and Functions
    I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt…
    12 5
    Answered ✓ 12 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • CONTAINS with Trigger Search
    In Formulas and Functions
    Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device …
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Formula to find the average word used in a column
    In Formulas and Functions
    Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
    78 13
    Answered ✓ 78 views 13 comments Most recent by Genevieve P. Formulas and Functions
  • Merge 2 column names from separate sheets into one in a single report
    In Using Smartsheet
    Hi I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. H…
    Answered - Pending Review
    22 4
    Answered - Pending Review 22 views 4 comments Most recent by MVP OPS Using Smartsheet