Using Smartsheet

Using Smartsheet

Discussion List

  • Abhiraj Joshi
    Answered Abhiraj Joshi 21 views 3 comments Most recent by Paul Newcome
    First post 03/21/20,Last post 03/23/20
    Hi, I have generated a report from different project sheets. I have a column (C) which has dates when a particular task is completed. Column D calculates the time taken to complete that task (Turn Around Time - TAT). I want to calculate …
    Using Smartsheet213
    Abhiraj Joshi
  • Dan Snodgrass
    Answered Dan Snodgrass 20 views 1 comment Most recent by Genevieve P
    First post 03/20/20,Last post 03/23/20
    I'm having a problem with the header row going missing on an embedded version of several reports. Hitting refresh using the vertical ellipsis brings it back. Any ideas on why this happens? Since this report is embedded on a web page, the…
    Using Smartsheet201
    Dan Snodgrass
  • Melisa Dannhauser
    Answered Melisa Dannhauser 32 views 2 comments Most recent by Melisa Dannhauser
    First post 03/20/20,Last post 03/23/20
    I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 d…
    Using Smartsheet322
    Melisa Dannhauser
  • Jörg Schmidt Novum Hospitality
    Accepted Answer Jörg Schmidt Novum Hospitality 14 views 3 comments Most recent by Paul Newcome
    First post 03/20/20,Last post 03/23/20
    Hallo, I use a column for postal codes (we habe 5 digits in Germany). For some cities the postal code starts with a "zero" (= 0). In the column the code only appears with 4 digits without the first 0. How can I change the forma…
    Using Smartsheet143
    Jörg Schmidt Novum Hospitality
  • Nasir@EBC
    Combining data from 2 sheetsAnswered Question
    Answered [email protected] 19 views 4 comments Most recent by Paul Newcome
    First post 03/20/20,Last post 03/23/20
    Hi I have created 2 sheets: Employee Onboarding Employee KRAs Both the above sheets have one common field: Employee ID. Now I want to create a report by referencing to this common data field (e.g., Employee ID) and "blend" the…
    Using Smartsheet194
    [email protected]
  • arkitektur
    copy paste rows in ios appAnswered Question
    Answered arkitektur 23 views 2 comments Most recent by arkitektur
    First post 03/21/20,Last post 03/23/20
    there is the ios 13.4 update with mouse support coming. i really hope this will bring a huge upgrade with the ios app and smartsheet in safari! especially copy-paste should be provided. i dont understand why this function is not available …
    Using Smartsheet232
    arkitektur
  • DJB
    Accepted Answer DJB 13 views 3 comments Most recent by Andrée Starå
    First post 03/21/20,Last post 03/21/20
    Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxe…
    Using Smartsheet133
    DJB
  • Becky Rooke
    Answered Becky Rooke 19 views 5 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/21/20
    I would like to ONLY send a notification when a specific set of multiple rows are Complete, not when each of these rows are individually Complete. I have spent hours playing with different Conditions, and I can not make it work. HELP!
    Using Smartsheet195
    Becky Rooke
  • Jennifer Amador
    Accepted Answer Jennifer Amador 21 views 3 comments Most recent by Andrée Starå
    First post 03/19/20,Last post 03/21/20
    Hi all, I had a formula in place yesterday that was working fine, but this morning is returning no match. In our sheet summary, I am trying to count the number of quarantined individuals in a specific market. Here is the formula I was usin…
    Using Smartsheet213
    Jennifer Amador
  • Nasir@EBC
    How to ensure data privacy?Answered Question
    Answered [email protected] 15 views 1 comment Most recent by Andrée Starå
    First post 03/21/20,Last post 03/21/20
    Hi I want some of my users to be able to submit data using forms. But in order to be able to fill out a form, the users must have shared access to the sheet that contains the input form in question. With sheet sharing enabled, the users …
    Using Smartsheet151
    [email protected]
  • Marcin P
    Marcin P 55 views 19 comments Most recent by Andrée Starå
    First post 02/04/19,Last post 03/21/20
    Hi Smartsheet, I am getting annoyed. Why if i want to print row from report, printout contains rows that are not visible in report? I have a special report where one specific column has to be hidden in printout only as this paper is passe…
    Using Smartsheet5519
    Marcin P
  • BESP10
    Accepted Answer BESP10 18 views 5 comments Most recent by Andrée Starå
    First post 03/18/20,Last post 03/21/20
    Hi, I am having trouble copying and pasting from one sheet to the next. I am trasnfering information and just need to copy and past but when I right click and copy on one sheet and then go to the next sheet and right click paste or CTRL V …
    Using Smartsheet185
    BESP10
  • Stephanie Boulanger
    First post 03/20/20,Last post 03/20/20
    This discussion has been moved.
    Using Smartsheet10
    Stephanie Boulanger
  • Felicia Wilson
    Accepted Answer Felicia Wilson 100 views 14 comments Most recent by Elizabeth Hernandez
    First post 01/29/20,Last post 03/20/20
    Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up?   When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an at…
    Using Smartsheet10014
    Felicia Wilson
  • Jakub Gill
    Answered Jakub Gill 224 views 6 comments Most recent by Paul Newcome
    First post 04/12/18,Last post 03/20/20
    Hello everyone!   I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are re…
    Using Smartsheet2246
    Jakub Gill
  • Mike L.
    Accepted Answer Mike L. 17 views 3 comments Most recent by Paul Newcome
    First post 03/20/20,Last post 03/20/20
    I have many formulas that use a default value if they return an error from an Index/Match. Well today during a meeting everything was returning a default value. I went to troubleshoot after the meeting and slowly the Index/Match values a…
    Using Smartsheet173
    Mike L.
  • Kayla Johnstone
    Accepted Answer Kayla Johnstone 21 views 5 comments Most recent by Paul Newcome
    First post 03/19/20,Last post 03/20/20
    I am trying to build a nested at risk formula based on the following triggers. -End date is today and Status is not complete it will trigger -There is not enough time between today and the end date for the duration period left. So, if dura…
    Using Smartsheet215
    Kayla Johnstone
  • Shirley Vue
    Accepted Answer Shirley Vue 20 views 9 comments Most recent by Paul Newcome
    First post 03/19/20,Last post 03/20/20
    I'm having issues with this formula, "=COUNTIF(CONTAINS({Tracking Sheet Range 1}, "Motorola", ({Tracking Sheet Range 3}, "In Progress")))" The term, 'Motorola' is in multiple cells in the same column and is us…
    Using Smartsheet209
    Shirley Vue
  • Shawn O'Banion
    Shawn O'Banion 51 views 3 comments Most recent by Ami Veltrie
    First post 05/13/19,Last post 03/20/20
    I shared a sheet with a non-licensed and gave them admin rights, but they are unable to make column property changes.   Is this the norm?  I thought that as long as they were given admin rights they could make those changes.  
    Using Smartsheet513
    Shawn O'Banion
  • Manu
    Answered Manu 9 views 7 comments Most recent by Paul Newcome
    First post 03/20/20,Last post 03/20/20
    Hi Folks Is there a way to send an automated email (via workflow) to multiple comma-separated emails in a cell ? I have tried, but so far have failed. Nothing seems to happen when I trigger the workflow. Any help would be appreciated.
    Using Smartsheet97
    Manu
  • Jörg Schmidt Novum Hospitality
    Accepted Answer Jörg Schmidt Novum Hospitality 8 views 1 comment Most recent by Paul Newcome
    First post 03/20/20,Last post 03/20/20
    Hallo, is there a way to keep a row in the 1st line although you sort the other rows by marking it as a favorit ?
    Using Smartsheet81
    Jörg Schmidt Novum Hospitality
  • Greg Brunt
    Accepted Answer Greg Brunt 16 views 2 comments Most recent by Greg Brunt
    First post 03/20/20,Last post 03/20/20
    Hi there The JIRA to Smartsheet sync that I have set up pulls through all the JIRA fields except Assignee. I have have tried setting up the column as both text/number and contract list but the data does not pull through. The workflow is se…
    Using Smartsheet162
    Greg Brunt
  • Alison Shen
    Accepted Answer Alison Shen 12 views 3 comments Most recent by Paul Newcome
    First post 03/19/20,Last post 03/20/20
    I've created a folder containing templates for sheets and reports all linking to a dashboard for a status report. I want my team to be able to copy these and use them for their partners. How can this be done easily? If they create the shee…
    Using Smartsheet123
    Alison Shen
  • TRMakai
    Answered TRMakai 38 views 1 comment Most recent by Sean Morgan
    First post 03/12/20,Last post 03/20/20
     I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management.  See word doc for details https://us.v-cdn.net/6031209/uploads/305/8Y65LUXQQ3QC.docx Any sugges…
    Using Smartsheet381
    TRMakai
  • Tomasz Gajdus
    Answered Tomasz Gajdus 23 views 3 comments Most recent by Sean Morgan
    First post 03/15/20,Last post 03/20/20
    Hi Community, I'd like to ask if there is any chance to set "alert someone" option on workflows, using specific distribution list, e.g. SmartSheet Contact Groups? In my sheet, I have combined few responsible departments and dep…
    Using Smartsheet233
    Tomasz Gajdus
  • Jenn Pestalozzi
    Accepted Answer Jenn Pestalozzi 35 views 16 comments Most recent by Jenn Pestalozzi
    First post 03/04/20,Last post 03/20/20
    Hi Team, I have a Smartsheet that has custom forms for each team member. Some team members choose to use the forms, and some choose to enter into the Smartsheet directly. What would be really great is to be able to ID WHICH form the line w…
    Using Smartsheet3516
    Jenn Pestalozzi
  • Pam Grant
    Answered Pam Grant 22 views 5 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/20/20
    I created an automated alert and selected the advanced columns to include the attachment but the recipient doesn't get the attachment. It works if I use an update request but I'm not really asking them to update anything. Should Attachme…
    Using Smartsheet225
    Pam Grant
  • TeeM
    Accepted Answer TeeM 34 views 12 comments Most recent by Andrée Starå
    First post 03/11/20,Last post 03/20/20
    Each project sheet has basically an identical structure and each line item is assigned to a specific person/user (Contact list). There are approximately 300 lines per project sheet. Each user has a report that shows only the tasks assigned…
    Using Smartsheet3412
    TeeM
  • Pamb10
    Accepted Answer Pamb10 33 views 15 comments Most recent by Andrée Starå
    First post 03/13/20,Last post 03/20/20
    I have a sheet that uses Hierarchy (on month) and is displayed in descending sort order. I have one calculated field that should be automatically calculated when a new row is added. When the person who will be entering data adds a new row,…
    Using Smartsheet3315
    Pamb10
  • Sidonia Posteuca
    Answered Sidonia Posteuca 46 views 7 comments Most recent by Andrée Starå
    First post 02/03/20,Last post 03/20/20
    Can I set up a form to populate multiple entries into one sheet? For example, I have a training log in which a form is filled out and entered into the log. However, many training's have multiple attendees in which all the training info is …
    Using Smartsheet467
    Sidonia Posteuca