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

  • Adobe PDF Fillable Form Submitted into Smartsheets
    In Using Smartsheet
    Hi, I had a PDF Fillable form that is used across our company. We use a PDF fillable form as it needs to be revisited and edited over the project period. Once the project is finished i was hoping the project owner could submit on the PDF s…
    Answered - Pending Review
    22 6
    Answered - Pending Review 22 views 6 comments Most recent by Andrée Starå Using Smartsheet
  • Automatically send a form when an email is entered
    In Using Smartsheet
    I'm looking for a form to be automatically sent when an email is entered into a separate sheet.  The form is from a separate sheet which is a survey. Once a new employee starts and we have their new company email address the recruiter woul…
    574 14
    574 views 14 comments Most recent by Andrée Starå Using Smartsheet
  • Add iCal to Outlook not showing meeting detail column
    In Using Smartsheet
    Hi. I am new. I created a smartsheet, in calendar view, I created an ical link to add to my local outlook. It imports ok, however, it doesn't show the event details/ which are in another column in the grid. Any way to add another column li…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Can you generate document from multiple forms in Document Builder?
    In Using Smartsheet
    Is it possible in Document Builder to generate a document from multiple forms? For example, I have projects A, B, and C. Project A uses Form A. Project B uses Form B. And Project C uses Forms A & B. Is there a way in Document Builder t…
    Answered - Pending Review
    25 4
    Answered - Pending Review 25 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Weird behavior with MATCH
    In Formulas and Functions
    HI, I'm trying to build a scoring system but i've got some strange behavior from MATCH. What i finally did was putting all items in one new grid , the formula in another and this is what i've got? Formula under Strategic fit : =MATCH([S…
    Accepted
    12 1
    Accepted Answer 12 views 1 comment Most recent by Rudy Moons Formulas and Functions
  • 0s on my charts
    In Using Smartsheet
    Hello - I'm creating basic bar charts and right now they look cluttered. How do I show the data values EXCEPT when that value is zero? I tried using the 0 formula on the source sheet, but it still showed up on the chart. 
    308 11
    308 views 11 comments Most recent by Andrée Starå Using Smartsheet
  • Changing Reference File
    In Formulas and Functions
    Hello, I have created these files: A raw data sheet - I will copy data extracted from various systems and paste them into this raw data sheet A sheet for metrics - a summary sheet for summarizing statistics from the raw data sheet Multiple…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Form Dropdown from another sheet
    In Using Smartsheet
    Hello, I have a sheet with a table of employee names & job title for all users in the company I have another sheet which logs the requests from these users. So one sheet is a list of people and another is a log of items they request f…
    Answered - Pending Review
    251 2
    Answered - Pending Review 251 views 2 comments Most recent by Wesley De La Harpe Using Smartsheet
  • Segmented Sheet Permissions
    In Using Smartsheet
    Hello, I have a sheet which is a cradle to grave view of the lifespan of a deal. The problem is each of the three departments have a different permission level. In the diagram below: (Image) Buyers have Modify rights to Columns Pri,1,2 bu…
    Answered - Pending Review
    11 13
    Answered - Pending Review 11 views 13 comments Most recent by Wesley De La Harpe Using Smartsheet
  • A single sheet that can pull data requested from sheet with Form responses
    In Formulas and Functions
    Hi, The end goal is a single sheet where someone can input something to pull from another sheet that was populated by form responses. Example using ice cream: Personnel completes form that provides how much they like different types of i…
    Answered - Pending Review
    43 7
    Answered - Pending Review 43 views 7 comments Most recent by Andrée Starå Formulas and Functions