Support

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.

Support

 

Discussion List

  • Michael Palko
    Michael Palko 10 views 0 comments Started by Michael Palko Formulas and Functions
    First post 01/22/20,Last post 01/22/20
    I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) …
    Formulas and Functions100
    Michael Palko
  • Alessandro Terranova
    First post 01/20/20,Last post 01/22/20
    Hi Community, I am in the process of creating a new Team workflow and I would really appreciate to discover how to easily import Trello Custom Fields into Smartsheet. I am aware of the Trello import procedure https://help.smartsheet.com/…
    Premium Apps and Integrations163
    Alessandro Terranova
  • Zachary Mitchell
    Answered Zachary Mitchell 19 views 3 comments Most recent by Paul Newcome Formulas and Functions
    First post 01/21/20,Last post 01/21/20
    I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patien…
    Formulas and Functions193
    Zachary Mitchell
  • NBurrus
    NBurrus 28 views 3 comments Most recent by Genevieve P. Using Smartsheet
    First post 06/27/19,Last post 01/20/20
    Does anyone know what happened to the Kindle Fire App? It is no longer in the app store and is now unavailable. 
    Using Smartsheet283
    NBurrus
  • jb@59069
    [email protected] 33 views 4 comments Most recent by Tucker Webb Using Smartsheet
    First post 01/18/19,Last post 01/20/20
    We started using Smartsheet in October 2017. It WAS a great help to us for time, expense tracking and project management. We made serious gains in productivity once we figured out how to use Smartsheet for our specific needs. All was well …
    Using Smartsheet334
    [email protected]
  • PR
    Accepted Answer PR 21 views 3 comments Most recent by Paul Newcome Using Smartsheet
    First post 01/17/20,Last post 01/17/20
    Hi! I've been trying to use a COUNTIFS formula to determine how many projects are 5 days out from the due date, as well as, which projects are either blank or In Progress. I definitely don't have the formula formatted correctly so it is no…
    Using Smartsheet213
    PR
  • Kristie Diersen
    SummaryAccepted Answer
    Accepted Answer Kristie Diersen 9 views 1 comment Most recent by Paul Newcome Formulas and Functions
    First post 01/17/20,Last post 01/17/20
    I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. https://us.v-cdn.net/6031209/uploads/277/JKXO5DMT4B8I.jpg Does anyone know what would be the best way to complete th…
    Formulas and Functions91
    Kristie Diersen
  • TrevorM
    First post 11/27/19,Last post 01/13/20
    We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
    Formulas and Functions6314
    TrevorM
  • amontemayor
    Accepted Answer amontemayor 43 views 20 comments Most recent by BrianBosché Using Smartsheet
    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
  • Jia Lee
    Answered Jia Lee 22 views 1 comment Most recent by Genevieve P. Using Smartsheet
    First post 01/08/20,Last post 01/09/20
    Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform https://community.smartsheet.com/discussion/1909/saving-coming-back-to-a-partially-complete-web-form https://community.smartsheet…
    Using Smartsheet221
    Jia Lee
  • David Skinner
    David Skinner 72 views 9 comments Most recent by Paul Newcome Using Smartsheet
    First post 08/21/18,Last post 01/08/20
    Has anyone received this error message before?  What are the options for large data?   (Image)
    Using Smartsheet729
    David Skinner
  • Chris Walker
    Accepted Answer Chris Walker 43 views 2 comments Most recent by Paul Newcome Formulas and Functions
    First post 01/03/20,Last post 01/06/20
    I have an original sheet with hundreds of rows of information (Source Sheet) that I am looking to summarize calculations in to a second sheet (Summary Sheet), in order to feed in to a dashboard. Source Sheet has two date fields that I am i…
    Formulas and Functions432
    Chris Walker
  • PR
    Progress Bar Roll-upAccepted Answer
    Accepted Answer PR 111 views 15 comments Most recent by Paul Newcome Formulas and Functions
    First post 08/05/19,Last post 12/30/19
    Hello, Is there a way for the progress bar of the children rows to roll up to a parent roll where it would display the average in the progress bar form?  As you can see in the screenshot, the progress bars are updated with the status of …
    Formulas and Functions11115
    PR
  • NBurrus
    First post 07/29/19,Last post 12/29/19
    Hello, Is anyone else disappointed in the pricing and the lack of availability of the Smartsheet Addons/Premium Features?  The features of these premium addons are pretty badass and would be useful. I feel like I would use dynamic report…
    Using Smartsheet265
    NBurrus
  • ehodgdon
    ehodgdon 54 views 5 comments Most recent by Andrée Starå Using Smartsheet
    First post 11/14/19,Last post 12/27/19
    Hello! I have a Smartsheet that I use to track multiple data entries each day from our vendor agents. I created a form for them to fill out for each instance, and they typically have no problem adding the data to my Smartsheet.  Recently…
    Using Smartsheet545
    ehodgdon
  • Colin Entrekin
    Colin Entrekin 78 views 5 comments Most recent by [email protected] Using Smartsheet
    First post 03/14/19,Last post 12/26/19
    I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a sheet, but who don't need t…
    Using Smartsheet785
    Colin Entrekin
  • Jorjie Higginson
    Answered Jorjie Higginson 22 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 12/17/19,Last post 12/17/19
    Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been deleted are still able to access into Smartsh…
    Using Smartsheet221
    Jorjie Higginson
  • Mark Bonham
    First post 04/30/15,Last post 12/12/19
    When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name.  So you end up with a new name entry the same as an already existing name in your contacts column.  Could they be…
    Archived 2015 Posts4442
    Mark Bonham
  • lisarae723
    lisarae723 36 views 6 comments Most recent by Andrée Starå Formulas and Functions
    First post 12/04/19,Last post 12/08/19
    Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified"  Here's …
    Formulas and Functions366
    lisarae723
  • slilienfeld113476
    First post 12/05/19,Last post 12/06/19
    I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box.   In other words, there are two columns to include in the count from my Comm…
    Formulas and Functions421
    slilienfeld113476
  • E Sa
    E Sa 27 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 12/05/19,Last post 12/06/19
    I understand this is not a place to deal with indivisual cases, but as I cannot reach anyone in Smartsheet, I've decided to write here. Thought I've been trying to contact Smartsheet since mid-November either through "Contuct us"…
    Using Smartsheet273
    E Sa
  • Andrée Starå
    Andrée Starå 32 views 4 comments Most recent by STEVEN ARTHRELL Using Smartsheet
    First post 08/01/19,Last post 12/05/19
    Hi, There seems to issues with date formats at the moment. I've had a few client's reach out with issues and I've also seen issues from others in the community.  If you're experiencing issues and If you haven’t already, I would recommend…
    Using Smartsheet324
    Andrée Starå
  • Jason Cocco
    First post 11/22/19,Last post 12/05/19
    =SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started …
    Formulas and Functions279
    Jason Cocco
  • jmussells
    jmussells 21 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 12/05/19,Last post 12/05/19
    I have an individual account which allows me 10 sheets. If I decided to delete a sheet after use will that restore 1 back to my remaining sheets???
    Using Smartsheet211
    jmussells
  • KDub618
    KDub618 35 views 2 comments Most recent by Paul Newcome Formulas and Functions
    First post 12/04/19,Last post 12/05/19
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    Formulas and Functions352
    KDub618
  • MikeCorvin
    MikeCorvin 34 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 12/04/19,Last post 12/04/19
    Is there a way to alter the Column Headers? IE Bold or Sizing or Font? I haven't seen any of these options but I just want to verify that it is truly the case.
    Using Smartsheet343
    MikeCorvin
  • cthrasher97141
    cthrasher97141 21 views 0 comments Started by cthrasher97141 Formulas and Functions
    First post 12/04/19,Last post 12/04/19
    Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario:  Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …
    Formulas and Functions210
    cthrasher97141
  • Chuck Perez
    Chuck Perez 23 views 1 comment Most recent by Andrée Starå Formulas and Functions
    First post 12/03/19,Last post 12/04/19
    Hi,    I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources),  who is on leave, time, names of the support person and who is on call. Also, includes …
    Formulas and Functions231
    Chuck Perez
  • TJSmith
    TJSmith 24 views 1 comment Most recent by TJSmith Using Smartsheet
    First post 12/03/19,Last post 12/03/19
    Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind!    Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this:  This site can’t be reached ht…
    Using Smartsheet241
    TJSmith
  • Michael.Baker
    Closed Michael.Baker 20 views 2 comments Most recent by Ford Archived 2017 Posts
    First post 08/07/17,Last post 12/01/19
    My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…
    Archived 2017 Posts202
    Michael.Baker