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

  • Zero Formula
    In Formulas and Functions
    Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much. 
    Answered - Pending Review
    764 15
    Answered - Pending Review 764 views 15 comments Most recent by Paul Newcome Formulas and Functions
  • Unable to Edit 1 Column on a Spreadsheet
    In Using Smartsheet
    Hello all, I am working on a collaborative spreadsheet on which I am an administrator. All I am trying to do update a vlookup function for one column, which references a different spreadsheet, on which I am also an administrator. The spre…
    Accepted
    16 1
    Accepted Answer 16 views 1 comment Most recent by KDM Using Smartsheet
  • Limit the number of entries on a form
    In Using Smartsheet
    I am trying to use a form to collect registration for an event. There is a limited number of attendee spots at the event. Is there a way to shut off the form after 100 entries? I could only find old posts on this and was hoping an update h…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by [email protected] Using Smartsheet
  • Pivot updates and charts in a dashboard
    In Premium Apps and Integrations
    I have a pivot sheet with all of the data formatted the way I need it but when it refreshes it pulls columns back in that are not needed which impacts a chart within my dashboard. Any suggestions? Thank you.
    Unanswered
    11 0
    Question 11 views 0 comments Started by asimone Premium Apps and Integrations
  • if formula help
    In Formulas and Functions
    I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome
    Answered - Pending Review
    17 4
    Answered - Pending Review 17 views 4 comments Most recent by Mike Wilday Formulas and Functions
  • Multiple IF statements
    In Formulas and Functions
    Hi, I'm attemping to assign PRICE to items based on CONDITION and CATEGORY but my limited skills with formulas are keeping me from my desired results. I'm hoping some one can help me out. In my PRICE column if have the following formula. …
    Accepted
    19 2
    Accepted Answer 19 views 2 comments Most recent by Ken Johns Formulas and Functions
  • Mobile App - Help with viewing public dashboards and favoriting forms
    In Premium Apps and Integrations
    I've created a dashboard with several links to Smartsheet forms we use. I've published the dashboard and shared the published link. All of our employees have the Smartsheet app on their work phones. When they click on the published link…
    Unanswered
    17 0
    Question 17 views 0 comments Started by Chris Armstrong Premium Apps and Integrations
  • Saving a folder of sheets with hyperlinks
    In Using Smartsheet
    Hi All, I have a folder full of sheets. Each time my company gets a new client I do a Save As and put all those sheets into that client's workspace. I have a checklist sheet in this folder that has hyperlinks to other sheets in the folde…
    Unanswered
    18 0
    Question 18 views 0 comments Started by Amanda Jeske Using Smartsheet
  • Creating auto number system
    In Using Smartsheet
    How can I Create a tracking # that can be automatically generated based on another column which has different sub categories: Department XYZ ABC What will be the auto number display system based on the department name?
    Accepted
    24 3
    Accepted Answer 24 views 3 comments Most recent by Mark Cronk Using Smartsheet
  • Data Uploader - protect existing data from being overwritten?
    In Premium Apps and Integrations
    Hi, I am working with several consultants from varying solutions at our company who are contracted at any given time to evaluate various pieces of an enterprise software solution at any given time. Sometimes a company may ask us to re-eva…
    Unanswered
    12 0
    Question 12 views 0 comments Started by Cindy Schick Premium Apps and Integrations