Using Smartsheet

Using Smartsheet

Discussion List

  • Stephanie G
    Stephanie G 69 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 Smartsheet693
    Stephanie G
  • KTarzia
    KTarzia 26 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 Smartsheet261
    KTarzia
  • terry.romanishen35591
    terry.romanishen35591 51 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 Smartsheet512
    terry.romanishen35591
  • J. Craig Williams
    J. Craig Williams 34 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 Smartsheet3412
    J. Craig Williams
  • Alex_Mac
    Alex_Mac 74 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 Smartsheet741
    Alex_Mac
  • tfry
    tfry 62 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 Smartsheet622
    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 Smartsheet661
    Sdiewalk
  • David M.
    David M. 12 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 Smartsheet122
    David M.
  • oj6_projmgr
    oj6_projmgr 17 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 Smartsheet171
    oj6_projmgr
  • Jim Hook
    Jim Hook 144 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 Smartsheet1448
    Jim Hook
  • PGreene
    PGreene 53 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 Smartsheet537
    PGreene
  • Morri Young
    Morri Young 37 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 Smartsheet373
    Morri Young
  • Cindy Hawkins
    Cindy Hawkins 53 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 Smartsheet533
    Cindy Hawkins
  • tye.gardner35371
    tye.gardner35371 226 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 Smartsheet22613
    tye.gardner35371
  • aguillot
    aguillot 63 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 Smartsheet639
    aguillot
  • tomacme
    tomacme 14 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 Smartsheet143
    tomacme
  • Andreas Gevay
    Andreas Gevay 1 view 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 Smartsheet11
    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 Smartsheet522
    jwheeler35166
  • syndarei
    syndarei 43 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 Smartsheet431
    syndarei
  • M_Fox
    M_Fox 13 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 Smartsheet132
    M_Fox
  • Bill Brandt
    Bill Brandt 178 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 Smartsheet1782
    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 Smartsheet241
    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 Smartsheet321
    412Doug
  • brownky77735241
    brownky77735241 41 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 Smartsheet413
    brownky77735241
  • Lisa Davis
    Lisa Davis 114 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 Smartsheet1141
    Lisa Davis
  • smiller
    smiller 55 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 Smartsheet552
    smiller
  • Randy Van Winkle
    Randy Van Winkle 12 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 Smartsheet121
    Randy Van Winkle
  • tylermh
    tylermh 42 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 Smartsheet422
    tylermh
  • Sarah Irving
    Sarah Irving 28 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 Smartsheet283
    Sarah Irving
  • Yessica
    Yessica 13 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 Smartsheet1310
    Yessica