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

  • Copy values from a formula
    In Using Smartsheet
    Hello everyone I would like to extract and keep only the value from a field caluclated by a formula : For example : - When the row is added, there is an automatic formula in my column that gives me the result 5 - I want to extract only the…
    Unanswered
    11 0
    Question 11 views 0 comments Started by Corentin Dal Farra Using Smartsheet
  • How to make the symbol show instead of the word in a form
    In Using Smartsheet
    Hi, I'm working on form entry for a survey and I'd like them to rate in a star system. I'm able to change the column type to symbol with stars, but in the form the selection is word based (one, two, three, etc) instead of star selections.…
    Accepted
    95 12
    Accepted Answer 95 views 12 comments Most recent by sarshad Using Smartsheet
  • Creation date column that breaks
    In Using Smartsheet
    Hello everyone, I have a problem with a sheet form and I can't find a solution on the community. Here is the use case : I have a sheet with a "creation date" column that is automatically generated. I added a form, and each time …
    Answered - Pending Review
    4 4
    Answered - Pending Review 4 views 4 comments Most recent by Corentin Dal Farra Using Smartsheet
  • Modifying rows in a form entry sheet with formulas
    In Using Smartsheet
    Hello everyone, I have a problem when I change some date in rows in my sheet, here is the example : A user fill information in a form, and then a new row is added in the sheet related to the form On that sheet, there are a lot columns that…
    Accepted
    9 1
    Accepted Answer 9 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Jira to Smartsheet
    In Using Smartsheet
    Hello, In a previous life I used the ceptah bridge plugin to link Jira information to MS project. Is a plugin necessary to export Jira information into a smartsheet gantt chart? Any information would be appreciated. Regards, Ch…
    Unanswered
    6 0
    Question 6 views 0 comments Started by Chad H Using Smartsheet
  • Gathering data from 1000 sheets
    In Using Smartsheet
    Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to …
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Daniel Dragoun Using Smartsheet
  • Form Notification - Email Address
    In Using Smartsheet
    Hi, I have created a Smartsheet's form with an automated process behind it that sends approval requests based on certain criteria. Is there a way to change the naming on the email that people receive so instead of people receiving it as Na…
    Unanswered
    8 0
    Question 8 views 0 comments Started by Gary Mcgrane Using Smartsheet
  • Conditional Logic on Forms
    In Using Smartsheet
    Hi I currently have conditional logic on forms that is working as I expected. I have a type that has Risk, Action, Issue I have additional columns for a) Description, b) Related Risk, c) Related Action d) Related Issue, e) more informati…
    Accepted
    5 4
    Accepted Answer 5 views 4 comments Most recent by Cierr Using Smartsheet
  • Sync a column change in multiple reports
    In Using Smartsheet
    I dont think Ive seen answer to this, but I have multiple reports in the same format that are used to separate different sales reps (not internal so current user wouldn't help). If I need to add a column to all the reports I have to do it …
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Column formula edit
    In Formulas and Functions
    I was able to convert a row formula to a column formula. However, now I need to edit it and am getting the message that only the sheet owner and admins can edit. I am the sheet owner. What do I need to do to edit the column formula? Thank…
    Accepted
    10 5
    Accepted Answer 10 views 5 comments Most recent by Deborah Stoneman Formulas and Functions