Using Smartsheet

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.

Using Smartsheet

 

Discussion List

  • Mark Silvester
    First post 02/25/20,Last post 02/25/20
    I've created separate shipping sheets for individual projects that detail if and when items have shipped. In the separate shipping sheets, I have a symbols column titled "Item Shipped?" which offers a choice of "yes, hold, a…
    Using Smartsheet20
    Mark Silvester
  • frobison14816
    frobison14816 79 views 11 comments Most recent by Crystal Gonzalez
    First post 10/03/18,Last post 02/25/20
    I have a sheet with a lot of docs uploaded, tried to load another yesterday and couldn't. I'm guessing there are # and/or size limitations for files for sheets, but I can't find that info anywhere - and even if I knew the limitations, I'm …
    Using Smartsheet7911
    frobison14816
  • Susanthi Kodali
    Answered Susanthi Kodali 17 views 3 comments Most recent by Paul Newcome
    First post 02/25/20,Last post 02/25/20
    Hi - I'm trying to build a report for "Upcoming Tasks" in the next 7 days. I would like to show parent and child hierarchy in the report. However, I am not able to figure out the logic in the report builder? Any help will be appr…
    Using Smartsheet173
    Susanthi Kodali
  • Netanel yosef
    Netanel yosef 84 views 4 comments Most recent by Paul Newcome
    First post 11/04/19,Last post 02/25/20
    how i can to do an automatic different color per row ? see example from excel: (Image)
    Using Smartsheet844
    Netanel yosef
  • NSAN
    NSAN 52 views 4 comments Most recent by Paul Newcome
    First post 11/07/19,Last post 02/25/20
    Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also …
    Using Smartsheet524
    NSAN
  • Daniel William Maycock
    Answered Daniel William Maycock 16 views 2 comments Most recent by Daniel William Maycock
    First post 02/24/20,Last post 02/25/20
    I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/n…
    Using Smartsheet162
    Daniel William Maycock
  • SamiV
    Accepted Answer SamiV 22 views 3 comments Most recent by Andrée Starå
    First post 02/20/20,Last post 02/25/20
    Hello, I have a workflow where I am trying to add a email note as a form and asking them to review attached document, take action. For some reason, the automation that I added, does not send the email verbiage I added. What am I doing wron…
    Using Smartsheet223
    SamiV
  • Timothy French
    Answered Timothy French 6 views 3 comments Most recent by Andrée Starå
    First post 02/25/20,Last post 02/25/20
    Is there a way to see the sheets we have and what they are connected to? I am thinking something along the lines of a master sheet showing links in and out to the sheets listed from a wide open perspective. I do not need to know the spec…
    Using Smartsheet63
    Timothy French
  • Antoine Retaggi
    Answered Antoine Retaggi 10 views 2 comments Most recent by Andrée Starå
    First post 02/25/20,Last post 02/25/20
    Hello, From what I have seen it's not possible, but I can't understand why, is there a way to have the gantt chart timeline displayed only for the period of the project (beginning the first month of the project and ending the last month fo…
    Using Smartsheet102
    Antoine Retaggi
  • Sidonia Posteuca
    A few questions..Unanswered Question
    Question Sidonia Posteuca 5 views 0 comments Started by Sidonia Posteuca
    First post 02/25/20,Last post 02/25/20
    When in Dynamic View and data is entered through a form, the filters I had set up get greyed out and disappear (i.e. I am filtering by JOB# and JOB NAME). This is not the case in my normal sheet however. The same data from the form entry i…
    Using Smartsheet50
    Sidonia Posteuca
  • Jacqueline Waller
    Jacqueline Waller 42 views 2 comments Most recent by Becky Swanwick
    First post 01/07/20,Last post 02/25/20
    It would help so much if there was a workflow that could send out the link to a form on a custom (daily, weekly, etc.) basis. Right now I have to create a row that triggers the form to be sent weekly and just put the link to the form in th…
    Using Smartsheet422
    Jacqueline Waller
  • Leslie Sutula (US - IFS)
    Multiple approval workflowsAnswered Question
    Answered Leslie Sutula (US - IFS) 23 views 3 comments Most recent by Andrée Starå
    First post 02/18/20,Last post 02/25/20
    Hi - I am trying to create 3 approval workflows. Each one as a sequence of approvers and some of those approvers are the same from workflow to workflow but for different approval purposes. I have been successful in setting up the first o…
    Using Smartsheet233
    Leslie Sutula (US - IFS)
  • Jeff McFarland
    Edit SubmissionsAnswered Question
    Answered Jeff McFarland 16 views 5 comments Most recent by Andrée Starå
    First post 02/10/20,Last post 02/25/20
    Is it possible for a user to retrieve a pre-filled form with their old submission if they want to change something?
    Using Smartsheet165
    Jeff McFarland
  • Maricarmen
    Accepted Answer Maricarmen 62 views 26 comments Most recent by Andrée Starå
    First post 01/15/20,Last post 02/25/20
    Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that fo…
    Using Smartsheet6226
    Maricarmen
  • Jonathan Barfoot
    Answered Jonathan Barfoot 21 views 2 comments Most recent by Cindy Smoker
    First post 02/21/20,Last post 02/25/20
    Is it possible in a form to create a contact list field type whereby the user is able to select a contact from their gmail contact list to populate that field in the form?
    Using Smartsheet212
    Jonathan Barfoot
  • TeeM
    Accepted Answer TeeM 24 views 12 comments Most recent by Andrée Starå
    First post 02/19/20,Last post 02/25/20
    I am trying to copy content from one sheet to a new sheet and I am now getting a message that the action can't be completed because my sheet has exceeded the maximum recommended size???? It is a brand new sheet, so what is the matter? The …
    Using Smartsheet2412
    TeeM
  • Si Spence
    Si Spence 49 views 7 comments Most recent by Andrée Starå
    First post 07/11/19,Last post 02/25/20
    Hi,  can anybody help me understand how I solve this error message please?  Thanks in advance. (Image)
    Using Smartsheet497
    Si Spence
  • Win LeDinh
    Answered Win LeDinh 29 views 10 comments Most recent by Andrée Starå
    First post 02/13/20,Last post 02/25/20
    This happens on 2 of my 10 sheets, and only started happening a few weeks ago. The moment I mouse over the grid of my sheet, the disk save icon immediately goes blue (enabled), thus indicating that something changed on the sheet. Thus wh…
    Using Smartsheet2910
    Win LeDinh
  • SAM B
    Answered SAM B 22 views 2 comments Most recent by Andrée Starå
    First post 02/21/20,Last post 02/25/20
    I work in product supply, and I need an alert generated when a cell in the "delivery date" column of my sheet goes from a date further out to a sooner date. For example, if the date was 3/10/20 and was changed to 2/28/20, I would…
    Using Smartsheet222
    SAM B
  • Shesha_K
    Answered Shesha_K 17 views 4 comments Most recent by Andrée Starå
    First post 02/21/20,Last post 02/25/20
    HELP!! I am having issues attempting to print several charts from my dashboard. They are fairly large charts and I would be fine if they were on multiple pages. However, when I attempt to print them, I am only getting portions of the char…
    Using Smartsheet174
    Shesha_K
  • Shawn Borror
    Answered Shawn Borror 7 views 1 comment Most recent by Andrée Starå
    First post 02/25/20,Last post 02/25/20
    I have weekly automation request that runs. Ideally if someone hasn't updated, I would like to send them an automated reminder until they do update the information. Is there a way to do this?
    Using Smartsheet71
    Shawn Borror
  • Garmon D
    Microsoft Forms & SmartsheetAnswered Question
    Answered Garmon D 17 views 1 comment Most recent by Andrée Starå
    First post 02/24/20,Last post 02/25/20
    As an organisation we're trying to centralise all our forms into MS Forms, and then building Power Automate flows to add rows to Smartsheet. I'm currently encountering issues when trying to add details from a Forms entry into a sheet with …
    Using Smartsheet171
    Garmon D
  • Raviteja Golla
    Accepted Answer Raviteja Golla 11 views 6 comments Most recent by Paul Newcome
    First post 02/24/20,Last post 02/25/20
    One of my user wants different smart sheets per fiscal year. The front end form will remain same but each year they want new smart sheet. So can I create a smart sheet which is linked to the existing form?
    Using Smartsheet116
    Raviteja Golla
  • Liz Lomax
    Answered Liz Lomax 9 views 2 comments Most recent by Andrée Starå
    First post 02/24/20,Last post 02/25/20
    Having now figured out how to use "Levels" in Card View, I cannot figure out how to make my selection apply in MS Teams. I've saved my sheet in Smartsheet with "Level 1" applied, and if I exit the sheet and reopen, I'm…
    Using Smartsheet92
    Liz Lomax
  • xav
    Accepted Answer xav 16 views 3 comments Most recent by Andrée Starå
    First post 02/24/20,Last post 02/25/20
    Hi Here is my challenge. One of my team enters projects into Sheet1 using a form which results in new rows on Sheet1. Once projects from Sheet1 are approved the manager checks a checkbox which triggers the move of the specific rows to Sh…
    Using Smartsheet163
    xav
  • Petr
    Answered Petr 7 views 1 comment Most recent by Andrée Starå
    First post 02/25/20,Last post 02/25/20
    Please check picture below. I would like to create similiar diagram. https://us.v-cdn.net/6031209/uploads/641/66W1KHC3IZRH.jpg Thank you in advance.
    Using Smartsheet71
    Petr
  • Jörg Schmidt Novum Hospitality
    First post 02/25/20,Last post 02/25/20
    Hallo, if you send an email out of Smartsheet ... it won´t be stored in Smartsheet like the chats and the update requests ? Furthermore, the answer to an email does not appear in Smartsheet. ist that true and - maybe wanted? or is there a…
    Using Smartsheet71
    Jörg Schmidt Novum Hospitality
  • Andrée Starå
    Andrée Starå 51 views 5 comments Most recent by Clair Henneberry
    First post 08/01/19,Last post 02/24/20
    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 Smartsheet515
    Andrée Starå
  • Nicholas_P
    Nicholas_P 28 views 4 comments Most recent by Clair Henneberry
    First post 08/01/19,Last post 02/24/20
    I have logged in today and all the dates in different columns are coming up in US format mm/dd/yy. Not had this issue before, I have been through my settings and region is correct but to no avail. Anyone have a fix for this?
    Using Smartsheet284
    Nicholas_P
  • Netanel yosef
    PermissionsAccepted Answer
    Accepted Answer Netanel yosef 13 views 1 comment Most recent by Andrée Starå
    First post 02/24/20,Last post 02/24/20
    hi, Is it possible to see who made the permissions changes when I have 3 admins in workspace ??? thanks
    Using Smartsheet131
    Netanel yosef