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
-
First post 08/31/17,Last post 09/01/17Hello! 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 Posts223Phillip -
First post 08/31/17,Last post 09/01/17I 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 Posts31mehulgangwal
-
First post 08/31/17,Last post 09/01/17Hi, Are there any user guides or training videos on how to use Smartsheet DataMesh? ThanksArchived 2017 Posts143Scott B
-
Closed paula.calia22401 2 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 08/31/17,Last post 09/05/17Hi, 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 Posts21paula.calia22401
-
Closed TJ (Tracie) Peters 12 views 1 comment 0 points Most recent by Mike Wilday Archived 2017 PostsFirst post 08/31/17,Last post 08/31/17The 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 Posts121TJ (Tracie) Peters -
First post 08/31/17,Last post 09/01/17I 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 Posts182Dion Garcia
-
First post 08/31/17,Last post 08/31/17Hi 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 Posts213Andrew Henderson
-
First post 08/31/17,Last post 08/31/17Is 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 Posts21sahershey
-
First post 08/31/17,Last post 09/01/17Hi I am wanting to display the FY weeks in Gantt view, not Fiscal year. Is there a way of doing this?Archived 2017 Posts161Erin_
-
Closed Gonzalo Suarez V. 30 views 5 comments 0 points Most recent by Mike Wilday Archived 2017 PostsFirst post 08/30/17,Last post 08/31/17Hi 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 Posts305Gonzalo Suarez V.
-
First post 08/30/17,Last post 09/01/17Does 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 Posts1311Ecqtjn01
-
Closed Brent Webb @ CAVU Aerospace 61 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 08/30/17,Last post 08/30/17Does 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 Posts611Brent Webb @ CAVU Aerospace
-
Closed Ania Bose 1 view 1 comment 0 points Most recent by Plan Assist Property Team Archived 2017 PostsFirst post 08/30/17,Last post 08/30/17Hi, 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 YouArchived 2017 Posts11Ania Bose
-
First post 08/30/17,Last post 08/30/18Really 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 Posts433jmergy
-
First post 08/30/17,Last post 08/31/17I am wondering if smartsheet keeps previous versions of spreadsheets on the off chance of the sheet being completely deleted?Archived 2017 Posts141kevin98189
-
First post 08/30/17,Last post 08/31/17Can 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 Posts281Jenna
-
First post 08/30/17,Last post 08/30/17Hi 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 Posts31StudioD23
-
First post 08/30/17,Last post 08/31/17I 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 Posts1061sgarner
-
First post 08/30/17,Last post 10/21/17I 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 Posts22PRITI KAKAR
-
Smartsheet Error: formName: ajax fa_loadContainer serverStatus: false serverStatusText: CriticalExceClosed Dennis A. Garcia 28 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 08/29/17,Last post 08/31/17What 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 Posts281Dennis A. Garcia -
First post 08/29/17,Last post 09/01/17Hi 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 Posts932Paul R
-
First post 08/29/17,Last post 08/31/17Does anyone know if you can use the smartsheet api for nodeJS with Angular?Archived 2017 Posts171russ356
-
First post 08/29/17,Last post 08/31/17Hi 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 Posts271mikenz1983
-
First post 08/29/17,Last post 08/30/17Is 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 Posts596ker9
-
First post 08/29/17,Last post 08/30/17Hi 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 Posts151Patti Steele
-
First post 08/29/17,Last post 08/30/17Hi, 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 Posts161davidharley
-
First post 08/29/17,Last post 08/30/17Hi, 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 Posts11Peter Smith
-
First post 08/29/17,Last post 05/31/18Hello, 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 Posts732Simon Cropper
-
First post 08/29/17,Last post 08/30/17Hi, 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 Posts15Cap -
First post 08/28/17,Last post 08/29/17Hello 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 Posts392Cecily H