Using Smartsheet

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Using Smartsheet

Discussion List

  • Julie Hill
    Answered Julie Hill 20 views 2 comments Most recent by austinurbanSeagate
    First post 01/13/20,Last post 01/13/20
    Ok... I just went to go put a formula in on my smartsheet and realized.... the columns don't have letters! (this is a sheet created from a form, so the column headers are titles instead... see my screenshot). what do I do? I'm used to d…
    Using Smartsheet202
    Julie Hill
  • Julie Hill
    Answered Julie Hill 18 views 2 comments Most recent by Andrée Starå
    First post 01/13/20,Last post 01/13/20
    See my example screenshot. I want to add more things to the "EXPENSE CATEGORY" question but I don't see a way to edit that! https://us.v-cdn.net/6031209/uploads/524/BFT7FI7B607J.png
    Using Smartsheet182
    Julie Hill
  • jessical111351
    Accepted Answer jessical111351 31 views 8 comments Most recent by jessical111351
    First post 12/17/19,Last post 01/13/20
    Previous versions won't load when using the proofing tool. PNG documents work fine, but PDFs just sit with a spinning wheel. https://us.v-cdn.net/6031209/uploads/144/63M59QRMPR8D.png
    Using Smartsheet318
    jessical111351
  • Maryann Burns
    Maryann Burns 15 views 1 comment Most recent by Andrée Starå
    First post 01/13/20,Last post 01/13/20
    We are using SmartSheet to collect and manage our team members weekly status reports.  We are collecting the data via a form.  Team members submit the form each week via the URL.  Is it possible to have the prior week's data entries pre-po…
    Using Smartsheet151
    Maryann Burns
  • Isaac Gallardo
    Accepted Answer Isaac Gallardo 46 views 5 comments Most recent by Paul Newcome
    First post 12/19/19,Last post 01/13/20
    I would like to know if there is a way to have a Master Contact List that could be used as a reference for all other sheets.  e.g.  In one sheet a have a column that says, Owner: Quality Manager. But, since I have multiple sheets with the …
    Using Smartsheet465
    Isaac Gallardo
  • dean.evans46601
    dean.evans46601 28 views 2 comments Most recent by Garry Radford
    First post 11/22/19,Last post 01/13/20
    The latest changes to how comments are typed and the inability to delete an attachment associated with the comment unless the comment is deleted are unbelievably bad. I have implemented a major solution for our service team but this makes…
    Using Smartsheet282
    dean.evans46601
  • Jana Brits
    Accepted Answer Jana Brits 11 views 1 comment Most recent by Andrée Starå
    First post 01/13/20,Last post 01/13/20
    Hey I've got a couple of templates, some of them are in workspaces and some in folders. I have created the template sheets myself. They contain sheets, reports and dashboards. We use some of these templates on a regular bases and some only…
    Using Smartsheet111
    Jana Brits
  • System
    System 29 views 6 comments Most recent by Andrée Starå
    First post 01/08/20,Last post 01/13/20
    This discussion was created from comments split from: Combining Two Sheets into a Report.
    Using Smartsheet296
    System
  • Digit
    Answered Digit 14 views 1 comment Most recent by Andrée Starå
    First post 01/13/20,Last post 01/13/20
    I have set up a number of automation processes and would like to print them so that I can replicate or share with individuals to review to ensure the right rules have been created. At present I am having to print screen and crop to get th…
    Using Smartsheet141
    Digit
  • Mike L.
    Answered Mike L. 15 views 3 comments Most recent by Andrée Starå
    First post 01/12/20,Last post 01/13/20
    It appears that renaming a sheet is not updating the sheet name (system column) value. Can anyone confirm that renaming a sheet does not update the system column value? Thanks, Mike
    Using Smartsheet153
    Mike L.
  • Richr
    Dependency ViewAnswered
    Answered Richr 16 views 1 comment Most recent by Genevieve P.
    First post 01/10/20,Last post 01/13/20
    Anyone know of a way to see the dependent tasks in Grid View? I know you can see them in Gantt but it would be much more efficient if you could see both the predecessor and dependency of a task in the same row
    Using Smartsheet161
    Richr
  • IdoIcan
    Accepted Answer IdoIcan 31 views 1 comment Most recent by Genevieve P.
    First post 01/10/20,Last post 01/13/20
    I wonder how to automate the approval process when If the Applicant = employee, then Department Manager Approve + GM Approve If the Applicant = Department Manger, then GM Approve It seem not possible using "condition" in the auto…
    Using Smartsheet311
    IdoIcan
  • FusiaSuede
    Answered FusiaSuede 23 views 3 comments Most recent by Andrée Starå
    First post 01/09/20,Last post 01/12/20
    I have created a template Sheet & Form to use over multiple PM jobs. Am I able to link the form answers to my sheet template 1 time so they will be link everytime a create a new job with my templates?
    Using Smartsheet233
    FusiaSuede
  • Marco Leippert
    Accepted Answer Marco Leippert 27 views 1 comment Most recent by Andrée Starå
    First post 01/10/20,Last post 01/12/20
    Hello, to present an overwiev of the projects I´m managing with Smartsheet I need a more "presentable" version of the Gantt chart. Is there any chance in Smartsheet to make the Gantt look different, for example to make some tasks…
    Using Smartsheet271
    Marco Leippert
  • Katya
    Answered Katya 13 views 3 comments Most recent by Andrée Starå
    First post 01/12/20,Last post 01/12/20
    The checkbox does not work in a template and it does not work in the sheet created from a template. And I cannot insert a new checkbox column in the sheet created from a template and have a checkbox. Am I doing something incorrectly or ar…
    Using Smartsheet133
    Katya
  • Peter Bromhead
    Accepted Answer Peter Bromhead 26 views 4 comments Most recent by Andrée Starå
    First post 01/10/20,Last post 01/12/20
    For example, when I add a date to 'start date' column, I would like my status column to automatically change to 'in progress'?
    Using Smartsheet264
    Peter Bromhead
  • Will Resendes
    Answered Will Resendes 16 views 1 comment Most recent by Andrée Starå
    First post 01/12/20,Last post 01/12/20
    Hello, We utilize the highlight feature in smartsheets to see what changes have been made since a user last logged in. However, this does not seem to work in the Android App. Is this possible?
    Using Smartsheet161
    Will Resendes
  • CC2019
    CC2019 36 views 2 comments Most recent by Ryan Gerding
    First post 10/02/19,Last post 01/12/20
    I am looking for a method for creating date constraints in smartsheet (I am assuming that there is not built in functionality) * As Soon As Possible * As Late As Possible * Finish No Earlier Than * Finish No Later Than * Must Start On * M…
    Using Smartsheet362
    CC2019
  • Gilles16
    Gilles16 50 views 12 comments Most recent by Andrée Starå
    First post 01/16/19,Last post 01/11/20
    HI all,  When I send a notification to someone, I dont want to send the link of the seeht, only the notification. Is it possible ? and how   Thank's
    Using Smartsheet5012
    Gilles16
  • SuzanneH
    Answered SuzanneH 30 views 14 comments Most recent by Andrée Starå
    First post 01/09/20,Last post 01/11/20
    I have a dashboard widget linking to a group of different smartsheets. I would like to add the last updated date (and name would be great too) so that the viewer will know if updates have been made without clicking into the sheet. What i…
    Using Smartsheet3014
    SuzanneH
  • Mattias
    Mattias 25 views 8 comments Most recent by Andrée Starå
    First post 09/16/19,Last post 01/11/20
    Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyb…
    Using Smartsheet258
    Mattias
  • Craig Cressey
    Craig Cressey 25 views 8 comments Most recent by Andrée Starå
    First post 10/10/18,Last post 01/11/20
    The latest app update does not allow form submissions to locked columns. We have 20 sheets assigned to 20 individuals that use forms to update their respective sheets. The sheets have locked columns to allow the sheet user to review and c…
    Using Smartsheet258
    Craig Cressey
  • Cheryl Camacho
    Answered Cheryl Camacho 20 views 2 comments Most recent by Andrée Starå
    First post 01/10/20,Last post 01/11/20
    Hello, I have set up an Automated Workflow to request an updated due date from the Assigned To person once their due date has passed. They are Shared to the sheet and are telling me they cannot update their row because they are View Only.…
    Using Smartsheet202
    Cheryl Camacho
  • jennytracy
    jennytracy 35 views 4 comments Most recent by Andrée Starå
    First post 11/04/19,Last post 01/11/20
    I am trying to prove that the automation workflow alert that was set up actually sent out to one of my users.  I can go to the View HIstory section of the Control Center intake sheet, but it does not show proof of who received the automati…
    Using Smartsheet354
    jennytracy
  • alisha_grommes
    alisha_grommes 30 views 7 comments Most recent by Katharine Dalton
    First post 03/22/19,Last post 01/10/20
    Hello all, I have been reading through the forum this morning on how to work around time duration in SS.  I used the trusty Travis/Ajayi  "formula from hell" to get an actual calculation!  yeah!!!     My problem is.... trying t…
    Using Smartsheet307
    alisha_grommes
  • amontemayor
    Accepted Answer amontemayor 43 views 20 comments Most recent by BrianBosché
    First post 10/01/19,Last post 01/10/20
    The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
    Using Smartsheet4320
    amontemayor
  • François Cales
    François Cales 33 views 4 comments Most recent by Cheryl Camacho
    First post 11/18/19,Last post 01/10/20
    First of all, english is not my native langage, please excuse my mistakes.   Hello all,   I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able …
    Using Smartsheet334
    François Cales
  • Elton Soares
    Accepted Answer Elton Soares 43 views 4 comments Most recent by Paul Newcome
    First post 01/10/20,Last post 01/10/20
    Hi, Guys. I have a smartsheet with private information on 50 people. Some of them are full licensed users, others are simple users (they use a company license, but they can't create) I want each of them to view only what regards to their …
    Using Smartsheet434
    Elton Soares
  • Brenda Sintu
    First post 01/10/20,Last post 01/10/20
    Currently we are using Smartsheet in the raw material quality department of my company for two different purposes: 1) Having vendors/suppliers submit yearly required compliance documents directly into Smarthseet (as opposed to forwarding t…
    Using Smartsheet141
    Brenda Sintu
  • Michael Pichler
    Answered Michael Pichler 22 views 1 comment Most recent by Paul Newcome
    First post 01/10/20,Last post 01/10/20
    https://us.v-cdn.net/6031209/uploads/917/5818H0LQZ4E5.jpg https://us.v-cdn.net/6031209/uploads/476/KB7W2AZ8FRR2.jpg Hello, I'm a starter in Smartsheet and try to build a Dasboard for FM KPIs in a Building. I also want to add a widget that …
    Using Smartsheet221
    Michael Pichler