Using Smartsheet

Using Smartsheet

 

Discussion List

  • Anna Mkrtchyan
    Announcement Anna Mkrtchyan 60 views 1 comment Most recent by [email protected]
    First post 08/05/20,Last post 08/07/20
    Join us on August 13th for a free webinar, Work seamlessly with Smartsheet and Microsoft 365 integrations. Increase productivity and real-time collaboration with our Microsoft 365 integrations. In this webinar, we'll share how your organi…
    Using Smartsheet601
    Anna Mkrtchyan
  • Anna Mkrtchyan
    Announcement Anna Mkrtchyan 246 views 2 comments Most recent by Paul Newcome
    First post 04/30/20,Last post 05/08/20
    Missed the webinar? Review the recording in the Smartsheet Learning Center. Top 5 tips for optimizing your sheets. Learn best practices for getting the most out of your Smartsheet, including sheet structure, collaborating in a variety of w…
    Using Smartsheet2462
    Anna Mkrtchyan
  • Tamizamuthan Vedachalam
    Answered - Pending Review Tamizamuthan Vedachalam 22 views 9 comments Most recent by Alyssa Feola
    First post 08/03/20,Last post 08/08/20
    Hello Experts, I am writing a workflow to copy and paste a particular Column value from 1 sheet to another sheet. However, the workflow is copying the entire column details from the spreadsheet.
    Using Smartsheet229
    Tamizamuthan Vedachalam
  • Smartsheet User
    Answered - Pending Review Smartsheet User 28 views 7 comments Most recent by Smartsheet User
    First post 06/13/20,Last post 08/08/20
    Hi, I would like to build forms with default minimum and maximum values and I would like the form to send me an email only for the values which are out of range. The min and max will be mainly numbers for different equipment. If the out of…
    Using Smartsheet287
    Smartsheet User
  • Cara Fagerholm
    Answered - Pending Review Cara Fagerholm 5 views 1 comment Most recent by Sean Morgan
    First post 08/07/20,Last post 08/08/20
    The data type of one of my columns is repeatedly converted to a “Date” data type from a "Dropdown (Single Select)" column type. When I return the data type to a single-select checklist, it is repeatedly converted back to a date d…
    Using Smartsheet51
    Cara Fagerholm
  • Kevin Smith
    Answered - Pending Review Kevin Smith 7 views 1 comment Most recent by Sean Morgan
    First post 08/06/20,Last post 08/08/20
    On a sheet, when I open an attached PDF, I get a link starting with https:// to that PDF. I want to use that URL on a dashboard but when I try to use it, I get the following error. (Image) This doesn't seem valid to me as I have no restri…
    Using Smartsheet71
    Kevin Smith
  • Olivia Gannon
    Answered - Pending Review Olivia Gannon 15 views 2 comments Most recent by lewis hamilton
    First post 08/07/20,Last post 08/08/20
    can you automate smartsheet with sharepoint?
    Using Smartsheet152
    Olivia Gannon
  • Kevin McIntosh
    Kevin McIntosh 7 views 1 comment Most recent by lewis hamilton
    First post 08/07/20,Last post 08/08/20
    I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of…
    Using Smartsheet71
    Kevin McIntosh
  • Jean-Robert Adrien
    Answered - Pending Review Jean-Robert Adrien 9 views 1 comment Most recent by lewis hamilton
    First post 08/07/20,Last post 08/08/20
    I used to see the login history of the users in my organization. Unfortunately once I deleted a user I cannot see their login history anymore. How should I go back and retrieve the history of actual and former smartsheet users of my organi…
    Using Smartsheet91
    Jean-Robert Adrien
  • paulen
    Answered - Pending Review paulen 12 views 2 comments Most recent by Sean Morgan
    First post 08/07/20,Last post 08/08/20
    Very strange! The conditional formatting of one of my spreadsheets just disappeared. I open the configurator and it is empty. Some settings are being applied but most are gone! I am the only one allowed to change and nothing has changed. I…
    Using Smartsheet122
    paulen
  • Thao Tran Phuong
    Multiple tasksQuestion
    Question Thao Tran Phuong 6 views 0 comments Started by Thao Tran Phuong
    First post 08/08/20,Last post 08/08/20
    Hi all, Why can't we do multiple tasks at once time: share all the sheets to one person (because can't share workspace) or to save as a new sheet to all folders/workspace? Thank you.
    Using Smartsheet60
    Thao Tran Phuong
  • Thao Tran Phuong
    Question Thao Tran Phuong 7 views 0 comments Started by Thao Tran Phuong
    First post 08/08/20,Last post 08/08/20
    Hi all, I'm just wondering why we can't share folders of workspace to collaborators. I only can share workspace or share sheets only. Some people only need to see sheets in one folder and it's really inconvenient. Thank you.
    Using Smartsheet70
    Thao Tran Phuong
  • Neil Fleming
    Help With Index/Match!?Accepted Answer
    Accepted Answer Neil Fleming 18 views 7 comments Most recent by Neil Fleming
    First post 08/05/20,Last post 08/08/20
    Man, this is frustrating! I've devoted a fair bit of time perusing all of the posts, but haven't been able to get this right yet. I've created a couple of sheets to act as training examples...the main one having products in one column, an…
    Using Smartsheet187
    Neil Fleming
  • Jim Schaffhausen
    Jim Schaffhausen 636 views 13 comments Most recent by Peter Rousseau
    First post 02/22/18,Last post 08/08/20
    Hi There-   I am trying to show a bar chart with 2 data points comparing $ amount of actual to budget. The Chart is not Starting at $0 it is starting at $800K so the data looks weird.  Can I choose the scale - say my 2 data points are $…
    Using Smartsheet63613
    Jim Schaffhausen
  • Enes Zorkul
    Answered - Pending Review Enes Zorkul 15 views 2 comments Most recent by Enes Zorkul
    First post 08/05/20,Last post 08/08/20
    Hi- While using the automated approval process, users are getting additional e-mail after they approve the request. Is there a way to disable that? It just creates unnecessary e-mails and notifications serves to very little to no purpose.…
    Using Smartsheet152
    Enes Zorkul
  • irene
    irene 248 views 6 comments Most recent by Sandra Healey
    First post 11/12/18,Last post 08/08/20
    Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing sam…
    Using Smartsheet2486
    irene
  • elektra_h
    Question elektra_h 8 views 0 comments Started by elektra_h
    First post 08/07/20,Last post 08/07/20
    I have the honor of partnering with a number of colleagues from across the organization to bring you the "How Smartsheet uses Smartsheet" track as part of our annual Engage Conference this year! Real use cases provide so much ins…
    Using Smartsheet80
    elektra_h
  • Nick Champlin
    Question Nick Champlin 7 views 0 comments Started by Nick Champlin
    First post 08/07/20,Last post 08/07/20
    Hello, Our company is going through a name change and with this our domain is changing also. I am wondering if there is anyway that we can bulk add their email with the new domain on it as an alternate email.
    Using Smartsheet70
    Nick Champlin
  • KBeem
    Answered - Pending Review KBeem 10 views 1 comment Most recent by [email protected]
    First post 08/07/20,Last post 08/07/20
    I use forms for surveys a lot. I'd like to be able to use a video to ask a question. For example, if the survey is for the CEO, I'd like to video the CEO actually asking the question. Also, I'd also like to refer to graphs in my question…
    Using Smartsheet101
    KBeem
  • Che Fortaleza
    Question Che Fortaleza 7 views 0 comments Started by Che Fortaleza
    First post 08/07/20,Last post 08/07/20
    Is there a way to view previously published smartsheets? I am looking for a way to look back and see previous contents.
    Using Smartsheet70
    Che Fortaleza
  • Shelby
    Answered - Pending Review Shelby 8 views 5 comments Most recent by [email protected]
    First post 08/07/20,Last post 08/07/20
    For documentation purposes, I need to Cc myself on all automated alerts that are sent to a vendor to notify the vendor that a warranty claim has been assigned to them. I set up a workflow that sends an alert to each contact that is include…
    Using Smartsheet85
    Shelby
  • Jamie Bedford
    Jamie Bedford 11 views 0 comments Started by Jamie Bedford
    First post 08/07/20,Last post 08/07/20
    Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments …
    Using Smartsheet110
    Jamie Bedford
  • Marc Lajoie
    First post 08/07/20,Last post 08/07/20
    I can not even see what the header in the third column says. I know it says CM Help Needed. All I can see is part of the N and the eeded. How do I fix this without making the column super-wide? (that would waste a lot of space) I tried t…
    Using Smartsheet80
    Marc Lajoie
  • Sandra Dye
    Question Sandra Dye 7 views 0 comments Started by Sandra Dye
    First post 08/07/20,Last post 08/07/20
    Hi. I'm sending a link to my report in an automated workflow as an "Alert Someone". The recipient email contains a link to the report and a snapshot of the report, but it is limited to 100 rows. A message appears at the bottom t…
    Using Smartsheet70
    Sandra Dye
  • Ken Hankoff
    Accepted Answer Ken Hankoff 11 views 3 comments Most recent by Ken Hankoff
    First post 08/07/20,Last post 08/07/20
    Hi Community, Many moons ago, I stumbled upon Smartsheet collateral that could be downloaded for use in Dashboards/Portals. Specifically, it was things link artistically designed lines that could break up a Dashboard page, and other simil…
    Using Smartsheet113
    Ken Hankoff
  • Carlos Yanes
    COUNTIFS HelpAccepted Answer
    Accepted Answer Carlos Yanes 8 views 4 comments Most recent by Carlos Yanes
    First post 08/07/20,Last post 08/07/20
    I'm trying to do a count if criteria within two columns meet particular criteria. I keep getting the unparseable error message. My formula is: =COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]7, AND{NCO-SD Intake Range 2}, [Assigned Total…
    Using Smartsheet84
    Carlos Yanes
  • Carlos Yanes
    Answered - Pending Review Carlos Yanes 9 views 4 comments Most recent by Carlos Yanes
    First post 08/07/20,Last post 08/07/20
    Is there a formula that would bring back multiple cell values within a column, if there are two specific conditions being met? For example, I have a list of users that are working on tasks that are listed in each cell. I'm wanting to bring…
    Using Smartsheet94
    Carlos Yanes
  • Alan Rappa
    Question Alan Rappa 8 views 0 comments Started by Alan Rappa
    First post 08/07/20,Last post 08/07/20
    Greetings my Smartsheeters-in-crime, And Happy Friday, all. Random question of the day here We have 60 product managers here all working off of a shared roadmap. I built a report, then modified it (yes, 60 times) for each of the product m…
    Using Smartsheet80
    Alan Rappa
  • Emerus CCC
    Auto RefreshQuestion
    Question Emerus CCC 6 views 0 comments Started by Emerus CCC
    First post 08/07/20,Last post 08/07/20
    Is there a way to set sheets to auto refresh? I have several reports set up for sheets, but will not refresh unless done manually. Also, when sheet B is updated from data entry from sheet A, conditional formatting does not update on shee…
    Using Smartsheet60
    Emerus CCC
  • Juston Oakes
    Juston Oakes 216 views 8 comments Most recent by Shelby
    First post 01/30/18,Last post 08/07/20
    Hi Community, I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it.  I hit a road block when trying to display the latest comment a field on the spreadsheet.  I'd still like to use t…
    Using Smartsheet2168
    Juston Oakes
  • @daniel
    @daniel 423 views 16 comments Most recent by Shelby
    First post 03/24/18,Last post 08/07/20
    Is it possible to reference the latest comment on a row, in a cell? And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opp…
    Using Smartsheet42316
    @daniel