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

  • IF Function Question - Symbol changes with date
    In Formulas and Functions
    Hello, I have been having some issues configuring a formula in smartsheets. I am trying to write a function where the Symbol (Green, Yellow, Red, Grey Balls) in the 'Status' column adjusts according to date in the 'Start' column. Green a…
    61 8
    Accepted Answer 61 views 8 comments Most recent by Paul Newcome Formulas and Functions
  • Gantt chart - date fields ok from formulas?
    In Using Smartsheet
    Hi, all. I have data in table where two date columns are derived from formulas. When I try to use the Gantt chart functionality it says that my grid needs at least two dates columns and doesn't allow me to continue. I have two date columns…
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • Missing Automation
    In Using Smartsheet
    I have a workspace with dozens of dashboards, sheets, reports etc. I am testing a notification automation, and it is not doing what I want it to do (there are way too many uemails) at this point I want to disable it. When I went back to…
    11 5
    Accepted Answer 11 views 5 comments Most recent by Paul Newcome Using Smartsheet
  • How to summarize and visualize sheet summary data of multiple sheets?
    In Using Smartsheet
    Hi! I've been using SmartSheet to track progress of different business units on a particular project. Each unit has its own sheet containing grid data that they fill out, as well as sheet summary data where I calculate different KPIs (e.g…
    Answered - Pending Review
    3 1
    Answered - Pending Review 3 views 1 comment Most recent by sdonnelly Using Smartsheet
  • Method to show comments from a sheet on a dashboard
    In Using Smartsheet
    Hello, Is there a way to surface just the comments from a sheet into a dashboard? Right now I have a report where the comments are seen at the row level, which is a step in the right direction. The limitation is I can only see the comment…
    12 3
    Accepted Answer 12 views 3 comments Most recent by mlanterman Using Smartsheet
  • This User cannot accept ownership!
    In Using Smartsheet
    Hello There, I had created a form in my Workspace and I'm trying to change the ownership to other registered user. I have encountered below message: "This user cannot accept ownership at this time. Please retain your ownership or s…
    905 12
    905 views 12 comments Most recent by Aatish Chaudhary Using Smartsheet
  • Can character limits be added to Text fields?
    In Formulas and Functions
    I have a free text comments field in a sheet, but I want to limit the number of characters people can enter into it. This is to try to keep comments brief and to the point. Is it possible? Thanks
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Where does the "Last Update" info reside?
    In Using Smartsheet
    Where does the Last Update information reside? I want to look at usage and which items are being accessed. I know the data exists, hence I see it displayed. How do I access it for a report?
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Steve Lyman Using Smartsheet
  • Creating a Lookup Sheet
    In Using Smartsheet
    Hello My Fellow Smartsheet Gurus, Today I am in need of some advice. I have a rather larger sheet used to track requests. I have a separate sheet that allows user to type in the a lookup ID and it pulls all the relevant information into …
    11 4
    Accepted Answer 11 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Does Smartsheet provides non-English language support ? for example - Japanese clients
    In Using Smartsheet
    HI , I've got a request from a user , he's wondering if Smartsheet can provide support to NON- English language users. If yes then how ? if the answer is NO , then how can I help non English speaking users. Appreciate the help
    4 0
    Question 4 views 0 comments Started by Yakshita Srivastava Using Smartsheet