Using Smartsheet

Using Smartsheet

Archives for April 2018

Discussion List

  • oberning
    oberning 384 views 8 comments Most recent by Andrée Starå Using Smartsheet
    First post 04/30/18,Last post 06/07/19
    I currently have a form sending data to a sheet, and then data from that first row displaying on a dashboard that I can print out for a visual representation of project data. Is there anyway that I can choose which row of data I want to sh…
    Using Smartsheet3848
    oberning
  • Hai N
    Hai N 13 views 1 comment Most recent by Chris McKay Using Smartsheet
    First post 04/30/18,Last post 05/01/18
    Hi Everyone Just trying to figure out why I can't choose myself for a dropdown menu list.  The error reads "Please enter or select a contact from the dropdown list. A sheet admin has restricted this column to dropdown contact…
    Using Smartsheet131
    Hai N
  • mark.gipson27746
    mark.gipson27746 29 views 3 comments Most recent by Bob May Using Smartsheet
    First post 04/30/18,Last post 09/06/19
      Is the ability to select multiple items from a dropdown still in development???
    Using Smartsheet293
    mark.gipson27746
  • james lonergan
    First post 04/30/18,Last post 04/30/18
    Is there a way to print multiple card views (same as the print from row function)?
    Using Smartsheet171
    james lonergan
  • justin46491
    First post 04/30/18,Last post 04/30/18
    I am trying to make a sheet and a form that will allow me to notify different people from different departments to make sure they get the correct information.  Can this be done and if so how.   Please let me know  
    Using Smartsheet15
    justin46491
  • Jerry Tutt
    Jerry Tutt 4 views 5 comments Most recent by Jerry Tutt Using Smartsheet
    First post 04/30/18,Last post 05/02/18
    I recently noticed that all dates including columns that are hidden are showing with my automated reminders.  I have a number of calculated dates that I don't want to display.  However, all of them now show on the reminders.  This is a fai…
    Using Smartsheet45
    Jerry Tutt
  • Maggie Young
    Maggie Young 61 views 1 comment Most recent by Mike Wilday Using Smartsheet
    First post 04/30/18,Last post 04/30/18
    Hello, I right click on the rows at the bottom of my sheet and delete but they keep reappearing. I'm fine with say three but there about 12. These also are printed. can you help?
    Using Smartsheet611
    Maggie Young
  • LSULLi00820
    LSULLi00820 24 views 1 comment Most recent by Shaine Greenwood Using Smartsheet
    First post 04/30/18,Last post 05/01/18
    Good Morning, I am struggling with presenting a project roll up including gant in a clean view.  I would say a program view is what I was wondering if anyone had some guidance on. Thank you. Lynn
    Using Smartsheet241
    LSULLi00820
  • Taru
    Taru 1 view 2 comments Most recent by Taru Using Smartsheet
    First post 04/29/18,Last post 04/30/18
    Dear All, As mentioned I am trying to cell link the Task and the start date. Post to creating the cell link I add a predecessor to the line,however the link to the Start Date disappears? Could someone please help me with this as this is c…
    Using Smartsheet12
    Taru
  • shahn.sria46436
    shahn.sria46436 23 views 1 comment Most recent by Chris McKay Using Smartsheet
    First post 04/29/18,Last post 04/30/18
    Hello all, I have been using smartsheet for about a year and I am all in. As Nerdy as this may sound, I enjoy using smartsheet to create solutions,  as I have done, still doing, for my insurance agency.  I would enjoy having a business, …
    Using Smartsheet231
    shahn.sria46436
  • tcgibson46341
    tcgibson46341 11 views 2 comments Most recent by Linda McGee Using Smartsheet
    First post 04/27/18,Last post 04/27/18
    I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% take…
    Using Smartsheet112
    tcgibson46341
  • Bri Boyer
    Bri Boyer 80 views 5 comments Most recent by Mike Wilday Using Smartsheet
    First post 04/27/18,Last post 04/27/18
    Hi all - I am working on a variance formula to first.. if error make a blank... and then to secondly... calculate the number of working days between to dates. I need the variance of our "planned end" and "actual end" co…
    Using Smartsheet805
    Bri Boyer
  • gabsy1972
    gabsy1972 17 views 8 comments Most recent by gabsy1972 Using Smartsheet
    First post 04/27/18,Last post 05/11/18
    hello all, my percentages are going int minus or over 100% . i currently use this formula , can anyone help    =(TODAY() - [Start Date]5) / ([End Date]5 - [Start Date]5) regards   Carl (Image)
    Using Smartsheet178
    gabsy1972
  • nickmerge
    nickmerge 49 views 1 comment Most recent by Chris McKay Using Smartsheet
    First post 04/27/18,Last post 04/30/18
    I want to create something that is several columns containing data is is continually updated - but only added to, no content is ever deleted. I'm calling this the "template". I'd like to be able to pull the "template data&qu…
    Using Smartsheet491
    nickmerge
  • Nathiele
    Nathiele 1 view 3 comments Most recent by Mike Wilday Using Smartsheet
    First post 04/26/18,Last post 06/11/18
    Hi All,   I am trying to change the today condition in this formula to today - 2 in order to become red few days before but it's not working.  Does someone know how I could do it? =IF(AND(Finish78 < TODAY(), [% Complete]78 < 1), &…
    Using Smartsheet13
    Nathiele
  • blairfarley
    blairfarley 13 views 2 comments Most recent by Andrée Starå Using Smartsheet
    First post 04/26/18,Last post 08/13/19
    I am trying to find a way to use the DONE checkbox to then notify the dependent task assignment that it is ready to launch. I have looked for solutions and come up with the idea of having a handoff column, but then that is just putting th…
    Using Smartsheet132
    blairfarley
  • john.spikula42751
    john.spikula42751 2 views 1 comment Most recent by Mike Wilday Using Smartsheet
    First post 04/26/18,Last post 04/26/18
    Got a rookie question... I'm using the system-generated creation date/time.  Time zone recorded looks to be correct (EDT).  I have a report that displays the time correctly.  That report is included in a dash board that also looks correct…
    Using Smartsheet21
    john.spikula42751
  • Tim
    Tim 15 views 4 comments Most recent by Tim Using Smartsheet
    First post 04/26/18,Last post 04/27/18
    Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
    Using Smartsheet154
    Tim
  • Maggie Young
    First post 04/26/18,Last post 01/29/19
    Can anyone advise. I have typed a paragraph into a cell and applied wrap text but I still only see a quarter of what I typed. thank you.
    Using Smartsheet1537
    Maggie Young
  • Lifestyle PMO
    Lifestyle PMO 16 views 1 comment Most recent by Shaine Greenwood Using Smartsheet
    First post 04/26/18,Last post 04/27/18
    Is there any enhancements on the way to make the report dashboards more configurable.  Risk Log - highlight report doesn't show the mitigation & when there too much text in a box goes off the page, is there something that can be done?…
    Using Smartsheet161
    Lifestyle PMO
  • mikenz1983
    mikenz1983 88 views 1 comment Most recent by MattH Using Smartsheet
    First post 04/25/18,Last post 04/26/18
    Hi Their i have a card view where i want my staff to enter in certain information, i want to be able to add some cells with some formulas that DO NOT appear on the card view but are viewable or present in the grid view. for example i hav…
    Using Smartsheet881
    mikenz1983
  • Vaynard
    Vaynard 181 views 13 comments Most recent by Andrée Starå Using Smartsheet
    First post 04/25/18,Last post 01/22/20
    Any one know if we can set auto email comments, instead of manually email comment? Thanks in advanced! (Image)
    Using Smartsheet18113
    Vaynard
  • Nik Lutz
    Nik Lutz 11 views 2 comments Most recent by Susan McCarthy Using Smartsheet
    First post 04/25/18,Last post 07/27/18
    Some of my admins of certain sheets cannot send rows to other sheets that they are also admins of. Anyone else have this problem? (yesterday it was working)
    Using Smartsheet112
    Nik Lutz
  • dana46031
    dana46031 1 view 2 comments Most recent by AcmeChad Using Smartsheet
    First post 04/25/18,Last post 04/25/18
    I am looking to use a form to make multiple entries into a sheet without the form going away once I hit submit, e.g., I should be able to fill an entire spreadsheet of tasks from one form. Thanks D A  
    Using Smartsheet12
    dana46031
  • bradley_B
    bradley_B 34 views 1 comment Most recent by Mike Wilday Using Smartsheet
    First post 04/25/18,Last post 04/25/18
    I am looking to set up a notification once everything in a specific column has been check marked.  Basically I have 10 things that need to be collected by someone every week, they are listed in rows in the sheet and have a checkbox next to…
    Using Smartsheet341
    bradley_B
  • lorierion
    lorierion 119 views 2 comments Most recent by lorierion Using Smartsheet
    First post 04/25/18,Last post 04/26/18
    A client filled out a form and said it would not submit. She checked all her info and it still would not submit. I tried it once with an upload and once without and it worked and had one other person check it and it was fine.  Anyone ever…
    Using Smartsheet1192
    lorierion
  • lhammond
    lhammond 263 views 7 comments Most recent by Andrée Starå Using Smartsheet
    First post 04/25/18,Last post 07/09/19
    I have a "closed" check box in my sheet.  Based on that being checked, I want to automatically fill a closed date in another column.  Not sure how to do that.  Help!  Thanks  
    Using Smartsheet2637
    lhammond
  • ggordon1
    ggordon1 2 views 1 comment Most recent by Shaine Greenwood Using Smartsheet
    First post 04/25/18,Last post 04/26/18
    Id like to summarize status for a list of users involved on multiple project checklist. The dashboard function tells me I can only use numerical data in reports/widgets. Is there something I am missing? I want to provide a quick glance at …
    Using Smartsheet21
    ggordon1
  • vramesh
    vramesh 131 views 1 comment Most recent by Sasan Using Smartsheet
    First post 04/25/18,Last post 04/25/18
    I have a huge data set and that need to be filtered owner-wise in my bar/pie chart. However, I do not see any filter option available. Please help me if someone is aware of this.
    Using Smartsheet1311
    vramesh
  • jbusch30
    jbusch30 16 views 6 comments Most recent by ddjerin Using Smartsheet
    First post 04/24/18,Last post 04/26/18
    Hi Everyone,  I have been trying to get my RYGB to automate based on the tasks dates.  I would like from the start date to 8 days to be Green...More than 10 days from start to be Yellow and the last 5 days before the end to be Red. I hav…
    Using Smartsheet166
    jbusch30