Using Smartsheet

Using Smartsheet

 

Discussion List

  • Ryan Nix
    Question Ryan Nix 2 views 0 comments Started by Ryan Nix
    First post 03/28/20,Last post 03/28/20
    Hello, we have a dashboard that we want share among different groups but in our testing, we saw that the email notification notes the various emails that are included. Is there a way to hide these email aliases? Since these are different g…
    Using Smartsheet20
    Ryan Nix
  • Kevin Minkoff
    Question Kevin Minkoff 4 views 0 comments Started by Kevin Minkoff
    First post 03/28/20,Last post 03/28/20
    https://us.v-cdn.net/6031209/uploads/486/QGUU7M9NWCFD.png Forms only allow data entry in a single column. That won't work. If I publish my Donation Calculator sheet, it retains the previous entries. Is there a way to force the sheet to cle…
    Using Smartsheet40
    Kevin Minkoff
  • Mohammed Sulaiman
    Answered Mohammed Sulaiman 14 views 2 comments Most recent by Mohammed Sulaiman
    First post 03/25/20,Last post 03/28/20
    I'm trying to create Line Chart widget on a Dashboard, to automatically update itself as the rows are added into the source sheet. How this was set up: In the original data sheet, the actual and expected performance of a parent level task…
    Using Smartsheet142
    Mohammed Sulaiman
  • jmpbell
    Limit to Dropdown values?Answered Question
    Answered jmpbell 11 views 8 comments Most recent by Andrée Starå
    First post 03/27/20,Last post 03/27/20
    We're creating a sheet where we want to have a column of a dropdown single select type. What is the limit to the number of values? For example, we have hundreds of departments we want to choose from, but have the submitter choose one from …
    Using Smartsheet118
    jmpbell
  • Christina Riot
    Answered Christina Riot 7 views 2 comments Most recent by Christina Riot
    First post 03/27/20,Last post 03/27/20
    I have found a few things via smartsheet community on this but I just cannot get this formula to work. I am working fast and furious, so maybe I'm missing something obvious. I am trying to look up a badge number from one sheet and match …
    Using Smartsheet72
    Christina Riot
  • Mark Silvester
    Question Mark Silvester 6 views 0 comments Started by Mark Silvester
    First post 03/27/20,Last post 03/27/20
    I am trying to create a report that pulls specific rows from multiple sheets (that are similar in structure) into a high level overview that shows: Opportunity Name SKU Adjusted Count Shipped Remaining Target Arrival Date I've pasted an …
    Using Smartsheet60
    Mark Silvester
  • Kevin Minkoff
    FormsAnswered Question
    Answered Kevin Minkoff 11 views 2 comments Most recent by Kevin Minkoff
    First post 03/27/20,Last post 03/27/20
    Hello, Is there a way to create a form where fields are displayed in multiple columns? If not, is there a way to publish a sheet where all data inputs are cleared upon exit? Thanks much!
    Using Smartsheet112
    Kevin Minkoff
  • Mike Sagel
    Digital signaturesAnswered Question
    Answered Mike Sagel 11 views 1 comment Most recent by Alejandra
    First post 03/26/20,Last post 03/27/20
    We have internal digital signatures through our Microsoft CA server. Is it possible to have a field in smartsheet that would accept and store a signature?
    Using Smartsheet111
    Mike Sagel
  • k.lakshminarasimham38821
    Answered k.lakshminarasimham38821 11 views 2 comments Most recent by k.lakshminarasimham38821
    First post 03/27/20,Last post 03/27/20
    I have an automated workflow that runs on an action item log daily. There are multiple owners across tasks, do we have an option of sending it out as one? That way the owners won't have to go into individual forms?
    Using Smartsheet112
    k.lakshminarasimham38821
  • Dan Snodgrass
    Answered Dan Snodgrass 28 views 2 comments Most recent by Dan Snodgrass
    First post 03/24/20,Last post 03/27/20
    Hi, I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freez…
    Using Smartsheet282
    Dan Snodgrass
  • Tibor Staub
    Tibor Staub 16 views 7 comments Most recent by Paul Newcome
    First post 03/27/20,Last post 03/27/20
    Hello I have a Task B that cannot start before Task A was finished and that should finish the same time as Task C. When I enter 2 predecessors for B, namely that Task A has FS and Task C has FF, the smartsheet always takes into account o…
    Using Smartsheet167
    Tibor Staub
  • bzgryzek
    managing supply chain riskUnanswered Question
    Question bzgryzek 11 views 0 comments Started by bzgryzek
    First post 03/27/20,Last post 03/27/20
    Do you have a template that could be used to manage supply chain risk? What template could be used in order to properly manage it?
    Using Smartsheet110
    bzgryzek
  • Jonathan Forrester
    Answered Jonathan Forrester 9 views 2 comments Most recent by Paul Newcome
    First post 03/27/20,Last post 03/27/20
    I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain …
    Using Smartsheet92
    Jonathan Forrester
  • Marla Berge
    Accepted Answer Marla Berge 13 views 5 comments Most recent by Marla Berge
    First post 03/26/20,Last post 03/27/20
    I have a smartsheet for a workflow. If at some point there is a change order, then the workflow needs to start back at the beginning and most of the populated cells need to be cleared out. Is there a formula to make this automatically ha…
    Using Smartsheet135
    Marla Berge
  • Dustin Shuman
    Accepted Answer Dustin Shuman 7 views 1 comment Most recent by Andrée Starå
    First post 03/27/20,Last post 03/27/20
    While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple e…
    Using Smartsheet71
    Dustin Shuman
  • Jacques Frein
    Answered Jacques Frein 6 views 13 comments Most recent by Jacques Frein
    First post 03/27/20,Last post 03/27/20
    Hello all, I have created a data sheet with KPI's for our team members (non-licensed users). I have created a dashboard so they could see their personal KPI's but I don't want them to have access to the full table, for confidentiality reas…
    Using Smartsheet613
    Jacques Frein
  • Bal - CPA
    Bal - CPA 59 views 3 comments Most recent by David Cramp
    First post 08/18/18,Last post 03/27/20
    Has anyone created worksheets to keep track of Client tasks for an accounting Practice? Trying to keep up with all of the assignments and tasks in one central place  
    Using Smartsheet593
    Bal - CPA
  • Marla Berge
    Accepted Answer Marla Berge 11 views 3 comments Most recent by Andrée Starå
    First post 03/26/20,Last post 03/27/20
    I have a column that is a multiple contact column and when I add multiple contacts, it adds that all on the same row, how do I get the names to be displayed 1 name per line withing the cell?
    Using Smartsheet113
    Marla Berge
  • Sepi Deh
    Sepi Deh 453 views 8 comments Most recent by Andrée Starå
    First post 07/18/18,Last post 03/27/20
    Hi, We would like to customize our smartsheet form in order to create an online opprtunity for Forum registration. For this purpose, we need to add the logos of our company and that of our partner. Would you please inform us how this ca…
    Using Smartsheet4538
    Sepi Deh
  • Jacques Frein
    Answered Jacques Frein 7 views 1 comment Most recent by Jacques Frein
    First post 03/27/20,Last post 03/27/20
    Hello all, I have created a data sheet with KPI's for our team members (non-licensed users). I have created a dashboard so they could see their personal KPI's but I don't want them to have access to the full table, for confidentiality reas…
    Using Smartsheet71
    Jacques Frein
  • Ken
    Deleting a UserAnswered Question
    Answered Ken 17 views 6 comments Most recent by Ken
    First post 03/25/20,Last post 03/26/20
    Why is it when I delete a user that they are still included in Workflows? Wouldn't it make sense that if a user is deleted, that they be deleted from everywhere in Smartsheet? Why must I manually remove that person from every workflow in e…
    Using Smartsheet176
    Ken
  • Geoff Baker
    Answered Geoff Baker 23 views 5 comments Most recent by Geoff Baker
    First post 03/21/20,Last post 03/26/20
    Hello, I am running a 3 stage approval process. If stages 2 or 3 REJECT the approval I have it setup to "Alert" the Stage 1 approver. https://us.v-cdn.net/6031209/uploads/336/JFIGJVM0XUBR.png I have triggered the workflow now 3 …
    Using Smartsheet235
    Geoff Baker
  • TeriOWY
    TeriOWY 9 views 0 comments Started by TeriOWY
    First post 03/26/20,Last post 03/26/20
    I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns. I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this w…
    Using Smartsheet90
    TeriOWY
  • Taru
    Taru 35 views 9 comments Most recent by Adam Olbur
    First post 04/06/18,Last post 03/26/20
    Dear All, Our program consists of 5 sub projects and each of them have their plan. All of these individual plans need to be rolled up into a  consolidated master plan that would finally track the inter-dependencies and the critical path. …
    Using Smartsheet359
    Taru
  • Clint Stitser
    Accepted Answer Clint Stitser 9 views 3 comments Most recent by Andrée Starå
    First post 03/25/20,Last post 03/26/20
    Hello Everyone, I build budgets in Smartsheets and then import actuals from our accounting department, provided on an excel sheet, which I then manually manipulate and upload to a different sheet in Smartsheets. Then I have a few differen…
    Using Smartsheet93
    Clint Stitser
  • Jessica Schemrich
    Answered Jessica Schemrich 14 views 4 comments Most recent by Paul Newcome
    First post 03/26/20,Last post 03/26/20
    I am trying to create a sheet summary that pull information from a form entry. The form entries will always appear in the first row. However, even when referencing the absolute cell, when a new form entry is populated, the sheet summary …
    Using Smartsheet144
    Jessica Schemrich
  • Daniel Cardenas
    Filter table based on list?Answered Question
    Answered Daniel Cardenas 19 views 6 comments Most recent by Paul Newcome
    First post 03/25/20,Last post 03/26/20
    In Excel, you can filter a table based on criteria defined in a range. (Data> Sort&Filter> Advanced Filter) In the screenshot below, the criteria range at the bottom would be used to limit rows displayed in the table above. Is it…
    Using Smartsheet196
    Daniel Cardenas
  • JMW_PNW
    Answered JMW_PNW 14 views 3 comments Most recent by Debbie Sawyer
    First post 03/25/20,Last post 03/26/20
    I created a Report in which several other sheets report data into. It also creates a link to the sheet where each line item came from. Which is very useful. Because I need to make this report available to over 250 people I created a &q…
    Using Smartsheet143
    JMW_PNW
  • Silvia Rangel
    Accepted Answer Silvia Rangel 13 views 7 comments Most recent by Andrée Starå
    First post 03/26/20,Last post 03/26/20
    Hello Community; I am trying to write a formula to check mark a field when 2 conditions are met; so far l have been able to make it work with 1 condition (see highlighted screenshot), but can't figure out how to add the 2nd condition to th…
    Using Smartsheet137
    Silvia Rangel
  • John Morgenthaler
    Accepted Answer John Morgenthaler 43 views 13 comments Most recent by John Morgenthaler
    First post 02/26/20,Last post 03/26/20
    I thought based on my personal settings I can get an email notification from workflows but I do not receive one. It only comes through Smartsheet at the top right where the bell is listed. How can I get this through email? https://us.v-cdn…
    Using Smartsheet4313
    John Morgenthaler