Using Smartsheet

Using Smartsheet

Discussion List

  • Kim Shaddix
    Accepted Answer Kim Shaddix 14 views 3 comments Most recent by Paul Newcome
    First post 07/23/20,Last post 07/29/20
    I have a dashboard that requires approvals - the only way I know to handle this is a link in the dashboard to the underlying sheet - where they can mark their approval. Three approvals are needed - and I want to automate it so it will se…
    Using Smartsheet143
    Kim Shaddix
  • Eric Fuller
    Eric Fuller 168 views 5 comments Most recent by Genevieve P
    First post 01/02/20,Last post 07/29/20
    Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.
    Using Smartsheet1685
    Eric Fuller
  • Anthony Noe
    Accepted Answer Anthony Noe 15 views 3 comments Most recent by Andrée Starå
    First post 07/23/20,Last post 07/29/20
    I have created a few groups and added members over the last 24 hours - however when I attempt to share sheets or dashboard - they do not appear as an option. I have submitted a ticket - but have not yet heard back from support. Am I missin…
    Using Smartsheet153
    Anthony Noe
  • Samara McCallum
    First post 07/27/20,Last post 07/29/20
    I am creating a SmartSheet whose rows are filled with the submission of the form and I wanted to utilize the hidden feature of the form to autofill a field when the form is submitted. I wanted this field to hold a formula that would select…
    Using Smartsheet193
    Samara McCallum
  • Anelise Wilhelm
    Anelise Wilhelm 167 views 6 comments Most recent by Andrée Starå
    First post 04/15/19,Last post 07/29/20
    We are not receiving any emails from our Smartsheets today.
    Using Smartsheet1676
    Anelise Wilhelm
  • Jignesh Desai
    Accepted Answer Jignesh Desai 15 views 8 comments Most recent by Paul Newcome
    First post 07/24/20,Last post 07/29/20
    Hello, I have a "Status" column with four symbols: Red, Yellow, Green, and Grey. I would like to add one more "Blue" color to it. Is it possible? Thanks in advance for your help. Regards, Jigs
    Using Smartsheet158
    Jignesh Desai
  • sravya.gupta127326
    Accepted Answer sravya.gupta127326 10 views 8 comments Most recent by Andrée Starå
    First post 07/29/20,Last post 07/29/20
    Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - i…
    Using Smartsheet108
    sravya.gupta127326
  • Gilles16
    Gilles16 276 views 14 comments Most recent by Andrée Starå
    First post 01/16/19,Last post 07/29/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 Smartsheet27614
    Gilles16
  • Kate Erickson
    Answered - Pending Review Kate Erickson 10 views 1 comment Most recent by Andrée Starå
    First post 07/28/20,Last post 07/29/20
    I have a sheet that is only displaying the Status and Priority dropdown lists. I have other dropdown lists that I would like to be able to select in the View By list. How can I get them to appear in the View By List?
    Using Smartsheet101
    Kate Erickson
  • director62476
    Answered - Pending Review director62476 64 views 12 comments Most recent by Genevieve P
    First post 07/06/20,Last post 07/29/20
    Today i noticed that in one of my sheets all Conditional Formatting is lost. Anybody else experiencing this? I've already submitted the issue to support.
    Using Smartsheet6412
    director62476
  • Bryan Sampson
    Bryan Sampson 337 views 6 comments Most recent by sravya.gupta127326
    First post 05/15/18,Last post 07/29/20
    I am pulling data from multiple cells within a Project Sheet. The issue is that for each cell, the information is being presented differently. In some cells, the data is presented BELOW the Cell Title while in other cells, the data is pres…
    Using Smartsheet3376
    Bryan Sampson
  • Michael Murphy
    Answered - Pending Review Michael Murphy 19 views 2 comments Most recent by Garo Stone-DerHagopian
    First post 07/13/20,Last post 07/29/20
    Are there any plans down the road for Smartsheet to add the ability to write code behind the scenes (similar to vba for Access, Excel, etc.) or incorporate vba?
    Using Smartsheet192
    Michael Murphy
  • Kaitey Elliott
    Accepted Answer Kaitey Elliott 8 views 3 comments Most recent by Andrée Starå
    First post 07/28/20,Last post 07/29/20
    If it isn't possible, what are your best recommendations for accomplishing the same thing? Thank you in advance!
    Using Smartsheet83
    Kaitey Elliott
  • Tamara Sprung
    Accepted Answer Tamara Sprung 50 views 11 comments Most recent by Andrée Starå
    First post 04/17/20,Last post 07/29/20
    I have an acct through my work. I actually have two accts. One I don't have the ability to make changes to a document unless the author gives me permission...nor do I have the ability to create a new doc. However...I do have the ability…
    Using Smartsheet5011
    Tamara Sprung
  • Michael Hair
    Accepted Answer Michael Hair 25 views 5 comments Most recent by Andrée Starå
    First post 07/21/20,Last post 07/28/20
    Is there a way that I can get a PDF version of a form automatically emailed to me every time that form is filled out? I would like this PDF to look similar to the form that is sent when a Send Update Request is requested under the Row Acti…
    Using Smartsheet255
    Michael Hair
  • Silvia Rangel
    Answered - Pending Review Silvia Rangel 20 views 3 comments Most recent by Paul Newcome
    First post 07/28/20,Last post 07/28/20
    Hello Community, I need help!! LOL By mistake deleted a workspace on 7/23/2020, l was not the owner but had Admin rights, l can see all the items in my deleted items folder: (Image) But when l try to Undelete them l am getting this error m…
    Using Smartsheet203
    Silvia Rangel
  • darren hubbard
    Accepted Answer darren hubbard 11 views 1 comment Most recent by Paul Newcome
    First post 07/28/20,Last post 07/28/20
    We wanted to create calendar views from our existing implementation projects and corporate HR functionality but the Calendar View is only showing data from the Primary Column. Is there potential future expansion to edit which columns are …
    Using Smartsheet111
    darren hubbard
  • Crystal.Jaimes90511
    Crystal.Jaimes90511 223 views 14 comments Most recent by Anna Keeton
    First post 10/01/19,Last post 07/28/20
    I am trying to calculate weeks out from a set date, and figured out a way, but wondering if there is an easier way without having a helper column (Days Diff column). The below columns is what I have:  Weeks Out    Day Diff    Start Date …
    Using Smartsheet22314
    Crystal.Jaimes90511
  • Kim Michael
    Formula QQuestion
    Answered - Pending Review Kim Michael 10 views 2 comments Most recent by Kim Michael
    First post 07/28/20,Last post 07/28/20
    Currently I have a cell with a formula to determine "Days Till Due" (=[Due Date]@row - TODAY()) based off a due date cell. I also have a status cell that has the drop down with: complete, in progress, not started, roadblock. I h…
    Using Smartsheet102
    Kim Michael
  • Joe Miner
    Accepted Answer Joe Miner 22 views 13 comments Most recent by Mike Wilday
    First post 07/27/20,Last post 07/28/20
    (Image) Hello, I am currently trying to make an equation driven total column. Currently I am experiencing issues with the formula not autofilling to the next row. I have looked at the help page that describes the necessary criteria for aut…
    Using Smartsheet2213
    Joe Miner
  • Scottf06
    Scottf06 919 views 15 comments Most recent by jmoser
    First post 03/18/19,Last post 07/28/20
    Hi,   I have recently gotten into using Dashboards within Smartsheet, amazing. Is there a way to display today's date in a widget?   Thank, Scott
    Using Smartsheet91915
    Scottf06
  • Nicole Emard
    Answered - Pending Review Nicole Emard 13 views 1 comment Most recent by SoS | Dan Palenchar
    First post 07/27/20,Last post 07/28/20
    I am providing weekly job status reports to each of my customers. I would like each report to have my company logo and the customers company logo on it. Creating a dashboard is the closest I have got but there are too many columns in the …
    Using Smartsheet131
    Nicole Emard
  • SoS | Dan Palenchar
    Answered - Pending Review SoS | Dan Palenchar 20 views 1 comment Most recent by Sean Morgan
    First post 07/24/20,Last post 07/28/20
    Hi everyone, I've taken this up with support but in the meantime (several days and counting). About a week ago or so I noticed that as I go about my day to day work, pretty much exclusively in Smartsheet and very active use, I get spontane…
    Using Smartsheet201
    SoS | Dan Palenchar
  • Rainier Hollands
    Accepted Answer Rainier Hollands 17 views 8 comments Most recent by Paul Newcome
    First post 07/21/20,Last post 07/28/20
    (File) Hi Everyone, I have a grid in which all my truck data goes in every day. For the data that goes into that grid everyday, I have created a column in which I want it to tell me what week of the month it is. I would also like my weeks…
    Using Smartsheet178
    Rainier Hollands
  • Michelle B
    Accepted Answer Michelle B 19 views 3 comments Most recent by Paul Newcome
    First post 07/27/20,Last post 07/28/20
    I am currently trying to have RYG balls change colours if they comply or don't comply with criteria. If Column Serialized? is Yes, and Serial number column is empty, then RED, if it has a serial number entered, then GREEN. If Column Seri…
    Using Smartsheet193
    Michelle B
  • Maryjo Reyes
    Answered - Pending Review Maryjo Reyes 15 views 8 comments Most recent by Paul Newcome
    First post 07/24/20,Last post 07/28/20
    Example: Description Wk1 Wk2 Wk3 Wk4 Structural 12 18 10 16 Mechanical 2 3 7 - Electrical 5 1 2 - Answer should be the latest or last cell value (should be number) input Structural 16 Mechanical 7 Electrical 2
    Using Smartsheet158
    Maryjo Reyes
  • Jörg Schmidt Novum Hospitality
    Accepted Answer Jörg Schmidt Novum Hospitality 10 views 1 comment Most recent by Andrée Starå
    First post 07/28/20,Last post 07/28/20
    Hi, I wonder if there is a way to transfer changes I make in a master (blank) sheet into the 180 child sheets I already produced and are filled with different data. Otherwise I would have to change 180 sheets again - which is... F.e. in …
    Using Smartsheet101
    Jörg Schmidt Novum Hospitality
  • stuartr
    Answered - Pending Review stuartr 74 views 3 comments Most recent by Andrée Starå
    First post 01/29/20,Last post 07/28/20
    I need some advice on creating a workflow that will meet the following requirement. We created a calendar and online booking form in smartsheets to allow people to submit requests via the form to attend an event. These requests are triage…
    Using Smartsheet743
    stuartr
  • sahilhq
    Answered - Pending Review sahilhq 27 views 3 comments Most recent by sahilhq
    First post 07/03/20,Last post 07/28/20
    Hi, Is there a way to reneame the error message Smartsheet charts show ("the source data for this chart has been changed") when there is no data in the underlying report it's being driven from? I have set up my charts in such a w…
    Using Smartsheet273
    sahilhq
  • Liz Lomax
    Answered - Pending Review Liz Lomax 18 views 1 comment Most recent by Anna Lee
    First post 07/23/20,Last post 07/27/20
    Hi, I have a daily task review that we run via Microsoft Teams. We have our smartsheet to-do list in teams and work our way through it. What I finding really frustrating is that I have to apply a filter to hide the completed tasks every ti…
    Using Smartsheet181
    Liz Lomax