Archived 2017 Posts

Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Archived 2017 Posts

Archives for August 2017

Discussion List

  • Phillip
    First post 08/31/17,Last post 09/01/17
    Hello!    I have tried to find the answer by browsing through questions already submitted about sumifs but I can't seem to find a question that addresses my issue.  Apologies if this has been asked and answered.   I'm attempting to sum…
    Archived 2017 Posts223
    Phillip
  • mehulgangwal
    Closed mehulgangwal 3 views 1 comment Most recent by Mehmet Zengin Archived 2017 Posts
    First post 08/31/17,Last post 09/01/17
    I want to find out the min, max and avg days taken to complete a project. We have around 68 management systems.   So, how can I put a condition for say ABC system was used in 6 projects (from its column) and find out the min, max and avg…
    Archived 2017 Posts31
    mehulgangwal
  • Scott B
    Closed Scott B 14 views 3 comments Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/31/17,Last post 09/01/17
    Hi, Are there any user guides or training videos on how to use Smartsheet DataMesh?   Thanks
    Archived 2017 Posts143
    Scott B
  • paula.calia22401
    Closed paula.calia22401 2 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/31/17,Last post 09/05/17
    Hi, Has anyone successfully used Smartsheet for a portfolio of projects? In particular, we are being asked to track dependencies between projects and to be able to produce a high level gantt chart across multiple projects. Thanks!
    Archived 2017 Posts21
    paula.calia22401
  • TJ (Tracie) Peters
    Closed TJ (Tracie) Peters 12 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
    First post 08/31/17,Last post 08/31/17
    The required field indicator is a red asterisk. When we built a form, we mentioned that anything with a red asterisk is required - but we can't customize any of the text (including the asterisk) in the description. So the referred asterisk…
    Archived 2017 Posts121
    TJ (Tracie) Peters
  • Dion Garcia
    Closed Dion Garcia 18 views 2 comments Most recent by Dion Garcia Archived 2017 Posts
    First post 08/31/17,Last post 09/01/17
    I have been successfully using a template to create project plans with a form.  I've created dozens of sheets from the template with no problem having the form transfer from the template to the new sheet. This morning that stopped working,…
    Archived 2017 Posts182
    Dion Garcia
  • Andrew Henderson
    Closed Andrew Henderson 21 views 3 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 08/31/17,Last post 08/31/17
    Hi all I have a sheet that using the decision symbols, can anyone help me with the formula that counts the number of Yes, No, Hold.  I would be happy if there was a way of just counting the number of the green yes   Many thanks       …
    Archived 2017 Posts213
    Andrew Henderson
  • sahershey
    Closed sahershey 2 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
    First post 08/31/17,Last post 08/31/17
    Is it possible to have a wider range of colors to choose from within the color pallet?  When making gantt charts it seems I am limited a bit too much.     
    Archived 2017 Posts21
    sahershey
  • Erin_
    Closed Erin_ 16 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/31/17,Last post 09/01/17
    Hi I am wanting to display the FY weeks in Gantt view, not Fiscal year. Is there a way of doing this?
    Archived 2017 Posts161
    Erin_
  • Gonzalo Suarez V.
    Closed Gonzalo Suarez V. 30 views 5 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 08/30/17,Last post 08/31/17
    Hi everyone, probably more of the same, but I cannot make my formula work... what I want is to change the color according to percentages in a different column, 0%to 33% Red, 34%to66%Yellow and 67% to 100% turn to green.  I have used this …
    Archived 2017 Posts305
    Gonzalo Suarez V.
  • Ecqtjn01
    Closed Ecqtjn01 131 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/30/17,Last post 09/01/17
    Does anyone know if it is possible to change the language in the date column of gantt sheets? Elsewhere I seem to be able to name columns etc in any language I want, but the months and days seem to be fixed. Many of my workers in China can…
    Archived 2017 Posts1311
    Ecqtjn01
  • Brent Webb @ CAVU Aerospace
    Closed Brent Webb @ CAVU Aerospace 61 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/30/17,Last post 08/30/17
    Does anyone have any C# code to just find a row and update the row background color (highlight the row).  I have it on another program, but because my rows have System Cells (Created By & Created Date) I have to completely rebuild the …
    Archived 2017 Posts611
    Brent Webb @ CAVU Aerospace
  • Ania Bose
    Closed Ania Bose 1 view 1 comment Most recent by Plan Assist Property Team Archived 2017 Posts
    First post 08/30/17,Last post 08/30/17
    Hi, I am trying to calculate task duration in hrs and minutes, for example Time Arrived 10:45 vs Time Left 11:57.  What function/formula should I use?  Thank You
    Archived 2017 Posts11
    Ania Bose
  • jmergy
    Closed jmergy 43 views 3 comments Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/30/17,Last post 08/30/18
    Really a bummer if we have card view going and I want to send it around for view/read only and people get a janky grid.  Can Smartsheet just add a default view setting to the publish functionality? That way we can determine what view we w…
    Archived 2017 Posts433
    jmergy
  • kevin98189
    First post 08/30/17,Last post 08/31/17
    I am wondering if smartsheet keeps previous versions of spreadsheets on the off chance of the sheet being completely deleted?
    Archived 2017 Posts141
    kevin98189
  • Jenna
    Closed Jenna 28 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/30/17,Last post 08/31/17
    Can smart sheets handle a sumif across different sheets? I want to do something like this.... In sheet B: SUMIF (range in sheet A, where the task  is the same as task in sheet A, add all the hours in sheet A)  - should return total hours…
    Archived 2017 Posts281
    Jenna
  • StudioD23
    Closed StudioD23 3 views 1 comment Most recent by Andrée Starå Archived 2017 Posts
    First post 08/30/17,Last post 08/30/17
    Hi all, I see so many great features with Smartsheet, but have been struggling with having the time to learn the program in order to properly use it. Wondering if anyone with excellent knowledge of the program can offer their services to…
    Archived 2017 Posts31
    StudioD23
  • sgarner
    Closed sgarner 106 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/30/17,Last post 08/31/17
    I have labor day in my non-working days' list. Smartsheet is still scheduling jobs on that day. I am running by predecessors. What is going on here?
    Archived 2017 Posts1061
    sgarner
  • PRITI KAKAR
    Closed PRITI KAKAR 2 views 2 comments Most recent by PRITI KAKAR Archived 2017 Posts
    First post 08/30/17,Last post 10/21/17
    I AM USING SMARTSHEET TO HANDLE MY BUSINESS, ie: TRAVEL AGENCY. I WANT A WAY BY WHICH ALL MY DRIVERS CAN UPLOAD ABOUT THEIR AVAILABILITY AND THEN ALL THESE THINGS COME DIRECTLY TO MY SHEET. AND THE DRIVERS SHOULDNT BE ALLOWED TO VIEW MY SH…
    Archived 2017 Posts22
    PRITI KAKAR
  • Dennis A. Garcia
    First post 08/29/17,Last post 08/31/17
    What is the cause of this error? How can we prevent this from happening again? Is there anyone experiencing the same error?  formName: ajax formAction: fa_loadContainer serverStatus: false serverStatusText: CriticalException errorCod…
    Archived 2017 Posts281
    Dennis A. Garcia
  • Paul R
    Closed Paul R 93 views 2 comments Most recent by Paul R Archived 2017 Posts
    First post 08/29/17,Last post 09/01/17
    Hi there, I am having difficulties with copy & pasting from one sheet to another, i.e. when I copy some new cells it still pastes the previous cells that I pasted.  Does anyone know how to overcome this / clear the clipboard? Thanks…
    Archived 2017 Posts932
    Paul R
  • russ356
    Closed russ356 17 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/29/17,Last post 08/31/17
    Does anyone know if you can use the smartsheet api for nodeJS with Angular?
    Archived 2017 Posts171
    russ356
  • mikenz1983
    Closed mikenz1983 27 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/29/17,Last post 08/31/17
    Hi All i have created a card view that are work packages for staff, i am requiring them to update the cards every 7/14 days with status and commentary. is their a way to build an alert that sends an email to either myself and/or the assi…
    Archived 2017 Posts271
    mikenz1983
  • ker9
    Closed ker9 59 views 6 comments Most recent by Mike Wilday Archived 2017 Posts
    First post 08/29/17,Last post 08/30/17
    Is there a way to keep track of reminders that have been sent?  It appears they go away once sent and there isn't anything that shows they were setup/sent.  Would like to be able to confirm that reminders went out.  
    Archived 2017 Posts596
    ker9
  • Patti Steele
    Closed Patti Steele 15 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/29/17,Last post 08/30/17
    Hi there, One of my clients has many events that occur at their main event. I have created a webform for the various stakeholders to request catering, AV, etc.  I had challenges in distilling the data down to a usable function.  There wer…
    Archived 2017 Posts151
    Patti Steele
  • davidharley
    Closed davidharley 16 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/29/17,Last post 08/30/17
    Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right.   We would like to give …
    Archived 2017 Posts161
    davidharley
  • Peter Smith
    Closed Peter Smith 1 view 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
    First post 08/29/17,Last post 08/30/17
    Hi,  I create the notification. I know that the receipt should be collaborator  (mean the smartsheet shared with them). However, may I ask if they are set as "Viewer", can they still  get notification.  I have may be more than …
    Archived 2017 Posts11
    Peter Smith
  • Simon Cropper
    Closed Simon Cropper 73 views 2 comments Most recent by TP Archived 2017 Posts
    First post 08/29/17,Last post 05/31/18
    Hello, I am collaborating in a project and most of the work being conducted is external to SmartSheets, which is being used as a planning tool. I would like the ability to construct an URL / Hyperlink that references particular tasks / ro…
    Archived 2017 Posts732
    Simon Cropper
  • Cap
    Closed Cap 1 view 5 comments Most recent by Cap Archived 2017 Posts
    First post 08/29/17,Last post 08/30/17
    Hi,   I am trying to show a rolling 6 months resource allocation matrix, so that I am able to include the resource allocation figure on the dashboard and need some help with the formula that will be required.  Tried the formula in the s…
    Archived 2017 Posts15
    Cap
  • Cecily H
    Closed Cecily H 39 views 2 comments Most recent by Cecily H Archived 2017 Posts
    First post 08/28/17,Last post 08/29/17
    Hello all -- I have created a column to show me how many days between "today" and the expected close date of a sale. This is the formula I'm using: =NETDAYS(TODAY(), Close Date16) This is working, but I have one problem: I d…
    Archived 2017 Posts392
    Cecily H