Using Smartsheet

Using Smartsheet

Discussion List

  • stephanie.blake67241
    stephanie.blake67241 41 views 4 comments Most recent by Andrée Starå
    First post 08/06/19,Last post 03/15/20
    I have a main sheet I use to gather information from underlying, linked sheets. Is there a way to get my base sheet to update with modified by date of those underlying sheets? (i.e. I have one sheet I use to roll up information from more d…
    Using Smartsheet414
    stephanie.blake67241
  • alwayslearning
    alwayslearning 43 views 5 comments Most recent by Andrée Starå
    First post 08/04/19,Last post 03/15/20
    I am new to SmartSheet.  I have a column called "Conference Call."  I set a conditional format that appears correctly in the grid view but not in the calendar view.  I'd like the word font/color to appear the same in the calendar…
    Using Smartsheet435
    alwayslearning
  • J Tech
    Accepted Answer J Tech 19 views 3 comments Most recent by Andrée Starå
    First post 03/11/20,Last post 03/15/20
    Hi, Is there a way when allocating a resource to be able to set what days they work, e.g. On Monday / Tuesday / Wednesday?
    Using Smartsheet193
    J Tech
  • Beronica Muller
    Sum Based on ValueAccepted Answer
    Accepted Answer Beronica Muller 23 views 12 comments Most recent by Andrée Starå
    First post 03/12/20,Last post 03/15/20
    Hello, I am trying to use a formula to calculate the number of inquiries created based in a particular column.  For example, I am trying to get the total number of inquiries that have been assigned to the responsible area NAOPS.Priority. …
    Using Smartsheet2312
    Beronica Muller
  • Cheng Kwee Chua (Hotmail)
    Smartsheet LimitationAccepted Answer
    Accepted Answer Cheng Kwee Chua (Hotmail) 14 views 5 comments Most recent by Andrée Starå
    First post 03/15/20,Last post 03/15/20
    Hi everyone, I understand Smartsheet have the following Limitations (plus many others). Can someone please clarify if the 10MB includes attachments ? The file cannot exceed 10 MB Up to 5,000 rows, 200 columns, or 200,000 cells can be impo…
    Using Smartsheet145
    Cheng Kwee Chua (Hotmail)
  • Steve C
    Custom Domain?Answered Question
    Answered Steve C 26 views 1 comment Most recent by Andrée Starå
    First post 03/14/20,Last post 03/15/20
    Hi there, I am an enterprise user with Smartsheet. I would like to setup a custom domain for my clients to access their Smartsheet view. For example: portal.mydomain.com They will be able to login using their custom credentials and acce…
    Using Smartsheet261
    Steve C
  • Cheng Kwee Chua (Hotmail)
    First post 03/15/20,Last post 03/15/20
    Hi there, I am currently evaluating Smartsheet using a trial account and created a form to capture data from a Worksheet in Smartsheet. When I tested the form, the data filled-in do not show up in the Worksheet. I am not sure if that it…
    Using Smartsheet141
    Cheng Kwee Chua (Hotmail)
  • Nicky Urso
    Answered Nicky Urso 10 views 1 comment Most recent by Andrée Starå
    First post 03/14/20,Last post 03/14/20
    Hi, Is this possible? I am creating a vendor repository. Business owner will initiate The first few fields and a notification will prompt info from the vendor to complete. I want the info from the vendor to updated in the line created by …
    Using Smartsheet101
    Nicky Urso
  • Saurabh Maheshwari
    Answered Saurabh Maheshwari 35 views 4 comments Most recent by Alejandra
    First post 03/12/20,Last post 03/13/20
    Hi, I have noticed inconsistency in how same contact is displayed differently across sheets. In one sheet it is displayed as name whereas in other sheet its displayed as email id. I understand that in one sheet where its displayed as name,…
    Using Smartsheet354
    Saurabh Maheshwari
  • Netanel yosef
    Netanel yosef 149 views 14 comments Most recent by Paul Newcome
    First post 11/04/19,Last post 03/13/20
    how i can to do an automatic different color per row ? see example from excel: (Image)
    Using Smartsheet14914
    Netanel yosef
  • LisaB:-)
    Accepted Answer LisaB:-) 22 views 6 comments Most recent by Andrée Starå
    First post 03/12/20,Last post 03/13/20
    Hi, I'd like to share a sheet with an external user, and allow them to edit update one column only. If I produce a report, then that will mean they would have to have access to the underlying sheet, which will contain information I don't w…
    Using Smartsheet226
    LisaB:-)
  • Scott Rae
    Hyperlink in a cellAnswered Question
    Answered Scott Rae 16 views 2 comments Most recent by Sean Morgan
    First post 03/12/20,Last post 03/13/20
    Hi there, I'm looking at hyperlinking a sheet into a cell. What are the limitations of doing this? (if the sheet is moved or/does the hyperlink expire) Many thanks in advance Scott
    Using Smartsheet162
    Scott Rae
  • Scott Verduin
    Average a column with zerosAnswered Question
    Answered Scott Verduin 19 views 2 comments Most recent by Paul Newcome
    First post 03/13/20,Last post 03/13/20
    Hello, How do you average column and not include the cells with zeros in them. Value 1 Value 1 Value 1 Value 0 Value 1 This column will grow larger and larger as more form data comes in. Thank you
    Using Smartsheet192
    Scott Verduin
  • Andre Drinkwater
    Answered Andre Drinkwater 18 views 2 comments Most recent by Paul Newcome
    First post 03/13/20,Last post 03/13/20
    Hi all, Can someone provide me a workaround here. I would like to run a report that lists all the tasks due to start in the next 5 days. But what I need is to include the Phase name, even though the Phase has already started. I have added …
    Using Smartsheet182
    Andre Drinkwater
  • Felicia Wilson
    Answered Felicia Wilson 17 views 1 comment Most recent by Andrée Starå
    First post 03/12/20,Last post 03/12/20
    My workflows are not triggering and I have not had any issues with them on previous days. Is there an issue with smartsheet workflows or a bug?
    Using Smartsheet171
    Felicia Wilson
  • MikeCorvin
    MikeCorvin 59 views 6 comments Most recent by Andrée Starå
    First post 11/07/19,Last post 03/12/20
    I am trying to figure out if there is a way to make a Private Comment in Smartsheet?  Let's say I have a Published Report that is viewable to anyone with the link; however, I want to make a comment on a line that I don't want anyone to be …
    Using Smartsheet596
    MikeCorvin
  • Nikki Hopper
    Answered Nikki Hopper 18 views 1 comment Most recent by Andrée Starå
    First post 03/12/20,Last post 03/12/20
    I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Pro…
    Using Smartsheet181
    Nikki Hopper
  • Subash Sitaraman
    Subash Sitaraman 19 views 0 comments Started by Subash Sitaraman
    First post 03/12/20,Last post 03/12/20
    Is anyone else frustrated with the contacts management within smartsheet? If I import contacts or add them to "My Smartsheet Contacts" , I am unable to add them to groups. So I add them to group first (email only) but then som…
    Using Smartsheet190
    Subash Sitaraman
  • Ginger Mason
    Ginger Mason 53 views 6 comments Most recent by Ramsay Zaki
    First post 05/01/18,Last post 03/12/20
    Hi, On the first day of each month, I send a report listing all documents published in the previous month. The report includes hyperlinks to each document's location.  Before the recent Smartsheet changes to reports, I would email the re…
    Using Smartsheet536
    Ginger Mason
  • Stanley Paul
    Test logAnswered Question
    Answered Stanley Paul 23 views 4 comments Most recent by Michele Thomas
    First post 03/09/20,Last post 03/12/20
    Can someone provide some insight to creating a testing log? Either point me to an existing Smartsheet template set that can be massaged to fit my testing needs or have a test log template set that you are willing to share.
    Using Smartsheet234
    Stanley Paul
  • Michele Deo
    Michele Deo 395 views 4 comments Most recent by Joshua Bowers
    First post 03/21/18,Last post 03/12/20
    I want to take a Smartsheet Dashboard that is interactive and put it as a web part within MS SharePoint 2016 site.  I use the page viewer webpart and provide the web page link offered up when I publish the dashboard, but once I apply it, a…
    Using Smartsheet3954
    Michele Deo
  • Qadeer Parekh
    Accepted Answer Qadeer Parekh 16 views 6 comments Most recent by Qadeer Parekh
    First post 03/12/20,Last post 03/12/20
    https://us.v-cdn.net/6031209/uploads/952/C658H10D4W96.jpg Multiple users are not SS users but that shouldn't matter since we are sharing a viewable link. Why would we get this error? Submitted a support ticket too and kind of urgent for us…
    Using Smartsheet166
    Qadeer Parekh
  • mikoker
    mikoker 251 views 11 comments Most recent by Andrée Starå
    First post 04/12/19,Last post 03/12/20
    I'm looking for a way to present attachments when placing a report widget on a dashboard. It looks as if this column is not presented although it is on the source report. Anyone with a suggestion on how to do that?
    Using Smartsheet25111
    mikoker
  • steven.nienaber105336
    Answered steven.nienaber105336 22 views 5 comments Most recent by Andrée Starå
    First post 03/03/20,Last post 03/12/20
    I have a Go Live date field that I want the recipient of my Send Update Request to be able to update. As shown in the pic below, it's not editable. The field in issue in the Smartsheet row to which this is linked is editable; i.e., not a…
    Using Smartsheet225
    steven.nienaber105336
  • Heather Holderness
    View completed formAnswered Question
    Answered Heather Holderness 30 views 4 comments Most recent by Andrée Starå
    First post 02/26/20,Last post 03/12/20
    A completed form fills into a smartsheet for me to view, however I would like to view the form itself with the fields filled in. Other than the notification email I receive that says the form has been completed, is there a way to view each…
    Using Smartsheet304
    Heather Holderness
  • Doug M
    Answered Doug M 27 views 5 comments Most recent by Andrée Starå
    First post 03/05/20,Last post 03/12/20
    We use a dashboard to display 5 different reports (task lists for 5 users). I want the users to be able to update the fields in the report (e.g. % Complete) directly from the dashboard, instead of having to go into the report itself (and …
    Using Smartsheet275
    Doug M
  • Jenna_Doucette
    Jenna_Doucette 18 views 3 comments Most recent by Andrée Starå
    First post 03/09/20,Last post 03/12/20
    Is there an easier way to disable all automatons at once if I have 41 rather than going through each one??
    Using Smartsheet183
    Jenna_Doucette
  • J Jones
    Answered J Jones 20 views 6 comments Most recent by Andrée Starå
    First post 03/09/20,Last post 03/12/20
    We are trying to use Smartsheet for Site Reports on Construction Sites. We are currently using forms for this as it seems like the most efficient method and allows easy attachment of images. Unfortunately it seems like when sending a row o…
    Using Smartsheet206
    J Jones
  • Mattias
    Mattias 30 views 3 comments Most recent by Andrée Starå
    First post 12/02/19,Last post 03/12/20
    Anyone else seen this? Not sure if it has been like this since the start or if its a new thing... Is there a setting to correct this? (Image)
    Using Smartsheet303
    Mattias
  • William Lafferty
    First post 03/06/20,Last post 03/12/20
    I am playing with the idea of creating a master reference sheet and using that as a cross reference for another. For example, I would have a master list of all leaders by geography. I am curious if I can devise a workflow based on select…
    Using Smartsheet224
    William Lafferty