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

  • Stephanie G
    Stephanie G 23 views 3 comments Most recent by Shaine Greenwood
    First post 01/15/18,Last post 01/24/18
    We require our licensed users to conduct semi-annual user access reviews on their Smartsheets. They need to remove users who no longer need access rights and delete or archive smartsheets that are no longer needed. (See attached jpg) If th…
    Using Smartsheet233
    Stephanie G
  • KTarzia
    KTarzia 10 views 1 comment Most recent by Mike Wilday
    First post 01/24/18,Last post 01/24/18
    I have multiple predecessors between lines 19- 29. Is there a way to add all these in without having to type each and every line #.   for example- I want to avoid having to type in the predecessor field, 19,20,21,22,23,24,25,26,27,28,29 …
    Using Smartsheet101
    KTarzia
  • terry.romanishen35591
    terry.romanishen35591 14 views 2 comments Most recent by terry.romanishen35591
    First post 01/24/18,Last post 01/24/18
    I am trying to create a template in Smartsheet that was housed in excel.  There is a bit of a complicated formula I am trying to transfer and having a heck of a time.   Here is the excel formula: =IF(ISNA(MATCH(5,'Project Assessment'!G6:G…
    Using Smartsheet142
    terry.romanishen35591
  • J. Craig Williams
    J. Craig Williams 12 views 12 comments Most recent by J. Craig Williams
    First post 01/07/18,Last post 01/24/18
    I need to be able to search by case. I want to search for RONIN or Ronin but not both. I have tried various forms of "RONIN" or "RONIN*" and have not been successful. The specific use case is a TRADEMARKED NAME O…
    Using Smartsheet1212
    J. Craig Williams
  • Alex_Mac
    Alex_Mac 23 views 1 comment Most recent by Shaine Greenwood
    First post 01/23/18,Last post 01/24/18
    Hi,   I have one smartsheet which tracks projects within a continuous improvement process where I can define if a project is high priority or not. I wish to pick-up this indication up and using in other sheets that reference the same pro…
    Using Smartsheet231
    Alex_Mac
  • tfry
    tfry 22 views 2 comments Most recent by [email protected]
    First post 01/23/18,Last post 01/24/18
    All -  We have data that is organized into a Target->Category->Item hierarchy, for example: Target: Big Event in Las Vegas Category: Digital Blogs Item: Blog about XYZ There is a "Target Date" for the top level Target,…
    Using Smartsheet222
    tfry
  • Sdiewalk
    First post 01/24/18,Last post 01/24/18
    I am trying to setup a Conditional Format formula to format a cell only when the cell contains a linked value of "Sheet Link from Cell in Other Sheet"
    Using Smartsheet121
    Sdiewalk
  • David M.
    David M. 9 views 2 comments Most recent by David M.
    First post 01/22/18,Last post 01/24/18
    We use Smartsheet notifications and receive emails frequently letting us know that a task was completed, and it is now our turn to work on a task. We use MS Outlook as our email client, and within here I like to use the preview pane. When …
    Using Smartsheet92
    David M.
  • oj6_projmgr
    oj6_projmgr 12 views 1 comment Most recent by Andrée Starå
    First post 01/23/18,Last post 01/24/18
    Is there no way to use a custom template via the "Create New / +" button on the tab bar instead of going to Home and selecting it over there? Thanks.
    Using Smartsheet121
    oj6_projmgr
  • Jim Hook
    Jim Hook 26 views 8 comments Most recent by Jeff Tolbert
    First post 01/22/18,Last post 01/23/18
    After the recent update I started having problems with one or two links here and there not properly updating. Double clicking on the receiving cell would point to the right cell in the source sheet but the value was wrong. I could repair t…
    Using Smartsheet268
    Jim Hook
  • PGreene
    PGreene 9 views 7 comments Most recent by Jim Hook
    First post 01/22/18,Last post 01/23/18
    Has anyone seen any updates regarding the Cell Linking issue? I reported it on Thursday, but they say it's in their Tier 3 team's hands for investigation. Thanks!
    Using Smartsheet97
    PGreene
  • Morri Young
    Morri Young 11 views 3 comments Most recent by Andrée Starå
    First post 01/23/18,Last post 01/23/18
    i get a lot of helpful information from the Community, Help and Blog sites. Is it possible to subscribe to a daily or weekly list of posts to these areas as part of my ongoing education about Smartsheet?
    Using Smartsheet113
    Morri Young
  • Cindy Hawkins
    Cindy Hawkins 14 views 3 comments Most recent by Andrée Starå
    First post 01/19/18,Last post 01/23/18
    How do I do this:  I need to collect data (name, address, etc) from new clients and I have created a Smartsheet for basic data.  I then email the new client with a link to the form and the client fills out the sheet. However, each client …
    Using Smartsheet143
    Cindy Hawkins
  • tye.gardner35371
    tye.gardner35371 56 views 13 comments Most recent by Andrée Starå
    First post 01/22/18,Last post 01/23/18
    Hello everyone This may be a simple fix; however, I am fairly new to Smartsheet and any insight would be appreciated. I built a report that is linked to three different sheets. They were originally imported from Excel that way the formula…
    Using Smartsheet5613
    tye.gardner35371
  • aguillot
    aguillot 22 views 9 comments Most recent by J. Craig Williams
    First post 01/19/18,Last post 01/23/18
    Is there a way to restrict or grant specific edit permissions with a collaborator? The permission settings under "Editor" are to broad, however, viewer does not have enough permission.  e.g. I have 10 rows in a sheet that one of…
    Using Smartsheet229
    aguillot
  • tomacme
    tomacme 10 views 3 comments Most recent by Andrée Starå
    First post 01/23/18,Last post 01/23/18
    Hello, I have been looking for the solution to share into a Workspace.  I see the Workspace and I have Editor access.  I do not see the options on the sharing sheet checkbox or under Home from the screenshot.  Please advise if I am missin…
    Using Smartsheet103
    tomacme
  • Andreas Gevay
    Andreas Gevay 7 views 1 comment Most recent by Andrée Starå
    First post 01/23/18,Last post 01/23/18
    Is there a possibility how I can insert a excel chart into sight without inserting a snapshot.
    Using Smartsheet71
    Andreas Gevay
  • jwheeler35166
    First post 01/19/18,Last post 01/23/18
    I have created a punch list with a column (checkbox) to mark completed items. I am sharing the sheet with collaborators (non-licensed) by weblink. This will be accessed through the web on a smartphone. These are our field installers and do…
    Using Smartsheet182
    jwheeler35166
  • syndarei
    syndarei 14 views 1 comment Most recent by Andrée Starå
    First post 01/22/18,Last post 01/23/18
    Has anyone used this form yet? Looking for an understanding of whether each employee needs to have their own sheet??
    Using Smartsheet141
    syndarei
  • M_Fox
    M_Fox 10 views 2 comments Most recent by J. Craig Williams
    First post 01/02/18,Last post 01/22/18
    Hi everyone, My company just finished our event in 2017, and I want to take the same exact smartsheet from last year and use it for 2018. Is there a way to take all my past bullets, and change the dates to 2018 without changing them all …
    Using Smartsheet102
    M_Fox
  • Bill Brandt
    Bill Brandt 22 views 2 comments Most recent by J. Craig Williams
    First post 01/02/18,Last post 01/22/18
    I have a bunch of numbers in a column, I want to find all the rows that include the # 13 in the number. The "contains" filter option does not work. Need suggestions on finding certain subsets of a longer number on the fly.
    Using Smartsheet222
    Bill Brandt
  • Harrisd1976
    First post 01/22/18,Last post 01/22/18
    I am trying automate pulling data entered in the form, that pulls into the sheet to then pull into a sight without using a report as the formatting is not very good, can anyone help?] I have attached a screen shot to support above.   Th…
    Using Smartsheet91
    Harrisd1976
  • 412Doug
    First post 01/19/18,Last post 01/22/18
    Hello Community, I would like to nest a short checklist of rows under an activity in a Project Sheet such that the nested rows representing the checklist do not require durations and dependencies. However, SmartSheet requires the duratio…
    Using Smartsheet111
    412Doug
  • brownky77735241
    brownky77735241 14 views 3 comments Most recent by Alison
    First post 01/19/18,Last post 01/22/18
    In some of my header rows I don't input data, so I want some of those cells to be blank.  How do I blank them?  See attachment. (Image)
    Using Smartsheet143
    brownky77735241
  • Lisa Davis
    Lisa Davis 25 views 1 comment Most recent by Shaine Greenwood
    First post 01/19/18,Last post 01/22/18
    We have a pipeline report pulling data from a primary sheet that we need to separate out by year. Is there a way to add a row or page break to distinguish and separate the two years? Also, In regards to header row at top of reports is the…
    Using Smartsheet251
    Lisa Davis
  • smiller
    smiller 25 views 2 comments Most recent by smiller
    First post 01/21/18,Last post 01/22/18
    Hi, everyone!   I would like to create a sheet or report that combines all of my other sheets so that I can look at them all together and sort by task. Ideally, this "master sheet" would update as each individual sheet is upda…
    Using Smartsheet252
    smiller
  • Randy Van Winkle
    Randy Van Winkle 16 views 1 comment Most recent by jdeckert
    First post 01/20/18,Last post 01/21/18
    Created a dashboard for multiple sheets that I would like to send to stakeholders once a week.  I don't see any options to send other than publishing a link and emailing myself
    Using Smartsheet161
    Randy Van Winkle
  • tylermh
    tylermh 15 views 2 comments Most recent by tylermh
    First post 01/18/18,Last post 01/19/18
    In smartsheet how do I select a checkbox for a group and have it select all checkboxes in that group? (Image)
    Using Smartsheet152
    tylermh
  • Sarah Irving
    Sarah Irving 12 views 3 comments Most recent by Andrée Starå
    First post 01/18/18,Last post 01/19/18
    As we are rolling out SS company-wide, many people are asking if we can have a single summary of notifications sent vs multiple emails each time.  Is this possible? Thanks!
    Using Smartsheet123
    Sarah Irving
  • Yessica
    Yessica 9 views 10 comments Most recent by Yessica
    First post 01/08/18,Last post 01/19/18
    Hello, My goal is to have a formula populate the dues dates with one condition.  Currently Drawing Due Date is populated 2 weeks from Order Date If the  "Type" Column is  "Q" then I need the Drawing Due Date to be 1 …
    Using Smartsheet910
    Yessica